LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Individual values from a Combobox List placed in textboxes Corey Excel Programming 2 January 30th 07 03:31 PM
Filling Textboxes from Combobox selection Corey Excel Programming 14 January 22nd 07 09:54 AM
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox Minitman[_4_] Excel Programming 3 October 26th 04 07:58 PM
How Do I Load A ComboBox On A UserForm Minitman[_4_] Excel Programming 4 October 26th 04 07:40 PM
searching for a combobox.value and filling in textboxes from results GregJG[_18_] Excel Programming 3 July 8th 04 12:41 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"