Listbox1

[dmcgimpsey]

Hi There, great resource here - I am new, and trying to develop a very simple application, the question may be very trivial to most of you.

What I desire is a listbox (drop down list) on an Excel worksheet that executes a VB macro. The macro can be anything, but in my case, it will direct the person who makes the selection to a specific worksheet.

here is what I have so far ...


--------------------------------------
Private Sub ListBox1_Click()

End Sub
--------------------------------------


I either need a selection that allows me to drop a text message, and then runs a macro, or ...

goes directly to a spreadsheet (ie: via path and filename)

I appreciate your help and keep up the good work, sorry for posting such a trivial question.

Regards