Populating cells based on a combobox OnChange Event

[mnixonG]

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

 

[Guest]

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.