| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
select macro within combo box or list box to
Thank you. I think I got the hang of it, now.
"Héctor Miguel" wrote: hi, Karin ! I have created 3 macros that generate 3 separate charts. I would like to be able to select any 1 of the 3 macros (charts) from a drop down list and have it display on my chart_output worksheet... use a cell with data validation (say, A1) and a direct entry list with your macro_names (i.e.): Macro1,Macro2,Macro3 then, copy/paste the following lines into "that" worksheet code module: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" And Target < "" Then Application.Run Target.Text End Sub use data validatin drop-down list to choose your macro and... if any doubts (or further information)... would you please comment ? hth, hector. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
| Use Combo Box to Select Month to Display Data on Chart | Charts and Charting in Excel | |||
| how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions | |||
| select last cell in a dynamic list using a macro | Excel Discussion (Misc queries) | |||
| I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Threaded Mode
