I want to create a userform that will have two columns of textboxes (3
in each column). one column of textboxes I will input info into and th
other textbox column I want the info to auto enter from a cell in m
spreadsheet.

example:

Userform 1
column 1
column 2
get info from cell Activeworksheet B10 25
get info from cell Activeworksheet B11 90
get info from cell Activeworksheet B12 40


CommandButton 1
CmdBtn 2
get client info from cell
dump column 2

So where do I start in making this type of form. Step by Step please.
I know how to make the userform but I do not know the code for gettin
the information for column 1.

Please Help

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46711

Userform 1
column 1 |column 2
get info from cell Activeworksheet B10 |25
get info from cell Activeworksheet B11 |90
get info from cell Activeworksheet B12 |40


CommandButton 1 |CmdBtn 2
get client info from cell |dump column

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46711