Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COMBOBOX AND TEXTBOXES QUESTION !!
Hello -
On a UserForm, I have Combobox1, Textbox1 and Textbox2. Values in Combobox1 come from Range("A:A"). What I want is to be able to select a value in Combobox1 and its corresponding values from Range("B:B") and Range("C:C") will automatically populate in Textbox1 and Textbox2 respectively. Example 1: If I select a dropdown value in Combobox1 that happens to be from Range("A6"), then Textbox1 should automatically populate value in Range("B6") and Textbox2 will also populate value in Range("C6") on the form. Example 2: If I select a dropdown value in Combobox1 that happens to be from Range("A10"), then Textbox1 should automatically populate value in Range("B10") and Textbox2 will also populate value in Range("C10")on the form. Any help would be appreciated. Thanks Jay *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox selection to fill in textboxes | Excel Programming | |||
Load UserForm ComboBox And Autofill 124 TextBoxes | Excel Programming | |||
Individual values from a Combobox List placed in textboxes | Excel Programming | |||
Filling Textboxes from Combobox selection | Excel Programming | |||
searching for a combobox.value and filling in textboxes from results | Excel Programming |