«
»

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)

Related posts:

  1. Excel VBA – Collections
  2. Excel VBA? How to I write the value of my text box onto the next available cell in column a?
  3. How can I check a value of a cell and consequently add one warning message using VBA in Excel?
  4. How can I create a Hash table of a file using VBA for excel?
  5. how to reference cells using excel 2003 VBA?

This entry was posted on Wednesday, September 1st, 2010 at 2:38 am and is filed under Learn Excel Macros. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply