| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using pop up boxes to supply a variable within a macro
Hi I have a piece of code as part of a macro which subtracts 1 from a value in cell D2 ActiveCell.FormulaR1C1 = "=RC[1]-1" Sometimes , I need to vary this number. Rather than open the macro and change the code each time , is it possible to program a popup to request the value of the variable , and once executed proceed with the rest of the macro? Any help appreciated. Best Wishes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro boxes: toggle on/off | Excel Discussion (Misc queries) | |||
| Macro Boxes | Excel Discussion (Misc queries) | |||
| Macro Boxes | Excel Discussion (Misc queries) | |||
| Entering Variable Text in Text Boxes...... | Excel Discussion (Misc queries) | |||
| Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
Threaded Mode
