L
Lucy
Hello
I was wondering if anyone could help me. I've managed to created a fairly
reasonable star chart using a scatter graph. I've also created several
buttons with the names of individual constellations on them so that when you
click on one of them it runs a macro taking the user to the star chart and
showing them the individual constellation.
What I would like to do is to have the names of the constellations in a drop
down box and to be able to click on whichever constellation and have it run
the same kind of macro. Having 40-odd gray boxes next to my chart doesn't
look very tidy and I think a drop down box that would run the same macros
would be much neater.
I hope I've made sense and that someone out there can help.
Many thanks
Lucy
I was wondering if anyone could help me. I've managed to created a fairly
reasonable star chart using a scatter graph. I've also created several
buttons with the names of individual constellations on them so that when you
click on one of them it runs a macro taking the user to the star chart and
showing them the individual constellation.
What I would like to do is to have the names of the constellations in a drop
down box and to be able to click on whichever constellation and have it run
the same kind of macro. Having 40-odd gray boxes next to my chart doesn't
look very tidy and I think a drop down box that would run the same macros
would be much neater.
I hope I've made sense and that someone out there can help.
Many thanks
Lucy