It's working!! I'm so happy! Thank you!!

Leith Ross Wrote:
Hello m3s3lf,

If I understand you correctly, this macro should work. This exampl
uses a Forms Drop Down with 3 lines for brevity. You can expand thi
example to run as many macros as you have entries.

First copy this code using CTRL+C then insert a VBA Module into you
Workbook's Project. Paste the code into the new Module. Add the name
of the macros to be called into the Select Case code below each Cas
statement. Be sure to save your changes using CTRL+S.

Link this Macro to the Drop Down. When the user makes a selection, th
macro will determine which line number was selected in the Drop Down
This line number then determines which macro will be executed.


Code
-------------------
Sub RunMacrosFromDropDown()

'Get the Name of ComboBox (Drop Down)
Cbo = Application.Caller

'Get the line number of the entry and the entry data
With ActiveSheet.Shapes(Cbo).ControlFormat
CboLine = .ListIndex
CboData = .List(CboLine)
End With

'Select Macro to run based on the Drop Down line selected
Select Case CboLine
Case 1
'Call First Macro
Case 2
'Call Second Macro
Case 3
'Call Third Macro
End Select

End Sub

-------------------


Sincerely,
Leith Ros

--
m3s3l
-----------------------------------------------------------------------
m3s3lf's Profile: http://www.excelforum.com/member.php...fo&userid=3487
View this thread: http://www.excelforum.com/showthread.php?threadid=55287