Martin Perera
Board Regular
- Joined
- Jan 17, 2005
- Messages
- 147
ok guys
I am trying to get to grips with a combo box. heres a simple senario probably with a simple solution........
It is created from the form toolbar.
it is very basic, it literally list the months of the year, Jan to feb from a range on the same sheet.
what I am trying to do is set each option(month)to run a sperate macro ie
I am making this as simple as possible just to get the hang of the procedure.
the question is HOW do I get the combo box to recognise more than one macro?
or
will it only recognise one macro and therefore that macro needs to somehow select the right macro to run? via some sort of case
cheers for any ideas
martin
I am trying to get to grips with a combo box. heres a simple senario probably with a simple solution........
It is created from the form toolbar.
it is very basic, it literally list the months of the year, Jan to feb from a range on the same sheet.
what I am trying to do is set each option(month)to run a sperate macro ie
- Jan -- GoTo K10
Feb GoTo k14 etc
I am making this as simple as possible just to get the hang of the procedure.
the question is HOW do I get the combo box to recognise more than one macro?
or
will it only recognise one macro and therefore that macro needs to somehow select the right macro to run? via some sort of case
cheers for any ideas
martin