How do I do this in Excel VBA?

I have a 2 column list box on a user form. When the list box choice is chosen, I want column 1′s data to go to Cell F16 and Column 2′s data to go to Cell F17. Does anyone know how this is done?

I guess you successfully populated your Listbox,…

The only way you can enter the column 2 data into cell F17 is to populate the cell with a VLookup formula:

=VLOOKUP(F16,B2:C29,2,False)

Leave a Reply