| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variable names in formula
I have a formula that is entered by VBA.
It obtains parameters from a dialog that is displayed to the user. Formula entered manually would be: Range("A8").FormulaArray = "=PISampDat(Parameters! R2C6,""*-12h"",""*"",""1m"", 1,""PIPV"")" Formula entered by VBA needs to have the variable names: 12h would be a concantenation of two variables... txtDuration.Value & Combobox3.Value 1m would also be a concantenation of two variables... txtInterval.Value & Combobox2.Value How do I substitute the variable names into the formula mess. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable file names | Excel Discussion (Misc queries) | |||
| variable file names | Excel Discussion (Misc queries) | |||
| Variable Names in Formulas | Excel Discussion (Misc queries) | |||
| Variable names in SQL | Excel Programming | |||
| Combining variable names | Excel Programming | |||
Threaded Mode
