| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a static set of data to use as input criteria
I currently have a macro that copies a sheet to a different workbook
dependant on who the adviser is. It currently picks the adviser name up from a cell in a sheet, but what I would like it to do is then when the macro is set off, some kind of input box comes up and gives the option of which adviser name to choose (be it a dropdown menu, a tick box etc) Anyone know how to do this? Cheers, cdb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retain part of formula's criteria as static | Excel Worksheet Functions | |||
| Replace static data by dynamic data without loosing all the formul | Excel Worksheet Functions | |||
| data validation input message locatioin has become static | Excel Worksheet Functions | |||
| Use a static set of data for input into a macro | Excel Discussion (Misc queries) | |||
| have input box. Need criteria entered to refer to cond. format criteria | Excel Programming | |||
Threaded Mode
