View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
oberon.black[_54_] oberon.black[_54_] is offline
external usenet poster
 
Posts: 1
Default Reverse Userform


I want to create a userform that will have two columns of textboxes (35
in each column). one column of textboxes I will input info into and the
other textbox column I want the info to auto enter from a cell in my
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 getting the
information for column 1.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=467707