| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Have macro force user to selecat a value
Part of my macro now has this line.
Range("D2").FormulaR1C1 = "CTR" It enters the value "CTR" in a cell. Now I need to modify it, so that it opens up a box in which the user can select a value from a list of 3 options. How do I do this? What code do I need? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I force user to enter their ID# before filling other data? | Excel Programming | |||
| How to force user function to recalculate | Excel Programming | |||
| Force user to save file with specified filename | Excel Programming | |||
| "Force" user to save file with specific name | Excel Programming | |||
| How do I force a user to fill in all cells in excel before saving | Excel Discussion (Misc queries) | |||
Threaded Mode
