| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating cells based on a combobox OnChange Event
I have an excel sheet that has a combo box populated by a list in a
separate worksheet. The combo box list is based on the first column, the second column has the description of the item. I would like to put the description that matches the currently selected item into the column next to the combobox. I dont know how to check what record is currently selected or how to retrieve the row number of the currently selected item any help would be great |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Populating cells based on a combobox OnChange Event
In Excel, press Alt + f11 to open the Visual Basic Edito. Click on help in
the VBE menu bar. In the Search Box, type 'ListIndex Property' and then read that information. Next type 'Selected Property' and then read that information. These are the two methods used to determine what is selected in a list box or combo box. " wrote: I have an excel sheet that has a combo box populated by a list in a separate worksheet. The combo box list is based on the first column, the second column has the description of the item. I would like to put the description that matches the currently selected item into the column next to the combobox. I dont know how to check what record is currently selected or how to retrieve the row number of the currently selected item any help would be great |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating a cell based on combobox data | Excel Programming | |||
| populating one list/combobox based on the results of another | Excel Programming | |||
| Populating cells based on calculation | Excel Worksheet Functions | |||
| OnChange Event for a Cell | Excel Programming | |||
| Combobox populating based on Option Button | Excel Programming | |||
Linear Mode
