| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Have macro force user to selecat a value
I would create a user form with a combo or list box with your options in it.
triger it with userform1.show and give it an "Apply" button to insert the value and close the userform. "Pluggie" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Have macro force user to selecat a value
Works like a charm. Thanks... I used two userforms already...
"Atishoo" wrote: I would create a user form with a combo or list box with your options in it. triger it with userform1.show and give it an "Apply" button to insert the value and close the userform. "Pluggie" wrote: 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? |
| Reply |
| 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) | |||
Linear Mode
