469,167 Members | 1,168 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Need to run 2 macros with drop down box

Hi there.

I have been using Excel in conjunction with Visual Basic for writing a fluid
flow program. I have 3 drop down boxes on the the spreadsheet and each time
I select an item from the drop down box it runs a particular macro that I
have written. Currently, each drop down box only runs 1 particular macro.
Is there any way that I can get a drop down box to run 2 macros?

TIA

Kevin
Jul 17 '05 #1
1 4871

"Kevin Long" <me@place.com> wrote in message
news:L7*******************@news20.bellglobal.com.. .
Hi there.

I have been using Excel in conjunction with Visual Basic for writing a fluid
flow program. I have 3 drop down boxes on the the spreadsheet and each time I
select an item from the drop down box it runs a particular macro that I have
written. Currently, each drop down box only runs 1 particular macro. Is there
any way that I can get a drop down box to run 2 macros?


Not sure if this is what you mean, but maybe

Public Sub Macro3()
Call Macro1
Call Macro2
End Sub

And have the drop down box run Macro3.
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

21 posts views Thread by Chris Reedy | last post: by
3 posts views Thread by Mike | last post: by
2 posts views Thread by Yoshitha | last post: by
1 post views Thread by pmarisole | last post: by
4 posts views Thread by TycoonUK | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.