Listbox Values From Cells

[Jaye7]

Can anyone please help with a listbox which contains the values/text of cells A1:B10 and then if any rows in the listbox equals Hello or 1234 it would then run macro named Macro3. Thanks

 

[xenou]

Mike has given you the solution to run macros by name. If you want to use "alternative names" then just adapt it for whatever selections (values) you would like to see in the listbox:

http://www.mrexcel.com/forum/showthread.php?t=484232

Note:
A very simple approach would be:
1) Load the listbox with values
2) Use a Select Structure:

Select Case Listbox1.Value
    Case "Hello" or "1234"
        Application.Run "Macro3"
End Select

If you use a Forms Listbox then you'll probably need to run this code on a change event in the linked cell that is hooked up to the listbox (these are easier to set up and look better so I would go with the forms listboxes).

You can also run macros from the macro dialog box.

 

[Jaye7]

Thanks Xenou,

I will incorporate Mike's example, however, can you please provide a vba script that will put the contents of cells i.e. A1:B10 in the listbox

 

[xenou]

Google is your friend:
http://support.microsoft.com/kb/161598
http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm
http://support.microsoft.com/kb/161534

If you use a Forms listbox it's as easy as setting the link range. But since you are using two columns, you'll be best of creating a "third" range where all 20 cells are in order top to bottom (simple formulas will populate this from A1:B10).