Sub MacroCaller()
Select Case ComboBox1.Value
Case "Bob"
Call GetBob
Case "Dave"
Call GetDave
Case else
Call Nobody
End Select

Does that help any?

Die_Another_Day
"Gryswynd" wrote in
message ...

Hello!
I am a little stuck on a project I am working on and a little new at
macro programing...

I have multiple macros that will search my spreadsheet, each one
designed to search for a specific Name and copy the entire row relating
to that instance of that name to a new sheet along with all other
instances of that name. So, for instance, I can pull all the "Bobs" out
of my data and they will be stored on a new sheet.

What I would like to do is have a Combo Box that displays all of the
names where each name is linked to the specific Macro. So I can pull
the box down, select "Bob" and the "Get Bob" macro runs, and if I
select "Dave" the "Get Dave" macro runs.

The problem is I am unsure of how to do this... I can create the Combo
Box, and assign a macro, but can only assign one macro, thus making it
so that every name I choose uses "Get Bob"...

Anyone know a way to possibly code the links to make it so that it
works correctly? Or anything?

Is what I want even possible? Cause I dont want a bunch of buttons if
at all possible :(


Thanks a bunch!


--
Gryswynd
------------------------------------------------------------------------
Gryswynd's Profile:
http://www.excelforum.com/member.php...o&userid=36559
View this thread: http://www.excelforum.com/showthread...hreadid=563092