lanhao
05-17-2006, 01:29 PM
Hi there, I've been working on an way of trying to get two separate values of data to combine into one value so it would be able to be outputted to a user form for some of my co-workers.
One of the values is Text, the other is a number. What I am basically looking to do is figure out a way of having the VB side of things, automatically combine the two values, so if cell H2 read 'A' and I2 read '21' it would automatically fill out the other information in another column and give the value 'A21'.
I'm not sure what kind of command or function would apply to this case specifically, and i was trying to look through some help files (and that did more damage than good). Any suggestions, tips/help would be greatly appreciated. :)
One of the values is Text, the other is a number. What I am basically looking to do is figure out a way of having the VB side of things, automatically combine the two values, so if cell H2 read 'A' and I2 read '21' it would automatically fill out the other information in another column and give the value 'A21'.
I'm not sure what kind of command or function would apply to this case specifically, and i was trying to look through some help files (and that did more damage than good). Any suggestions, tips/help would be greatly appreciated. :)