View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Minitman Minitman is offline
external usenet poster
 
Posts: 293
Default Load UserForm ComboBox And Autofill 124 TextBoxes

Greetings,

I am trying to load a ComboBox on a UserForm with a named range which
has 27 rows and 124 columns. I need to choose a row from the 1st
column of the ComboBox drop down menu. If possible, I would like to
see, as I scroll down, all of the data in the ComboBox change in all
of the TextBoxes as they fill in.

Anyone have any ideas as to how this is done?

Any help would be appreciated.

-Minitman



I have a UserForm with 123 TextBoxes Labeled Input_2 thru Input_
124. I need to fill them from a ComboBox labeled Input_1. The
RowSource for Input_1 is a named range called rInput1 thru rInput31.
the actual named range is determined by a setting when I start