Populating cells based on a combobox OnChange Event

M

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
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Highlight multiple items in listbox based on textbox item 1
populate a combobox based on unique values in another workbook 16
comboboxes, extracting specific item 7
Combobox list based on choice in previous combobox 0
Combobox items based on choice in previous combobox 0
Conditional listbox cell populating 4
Use VLOOKUP to populate text box on form 8

Top