| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variables... Help!
Can anyone help?
At the minute I have script that reads: Windows(Ind ot data.xs).Activate Sheets(190906).Select But I want the 190906 to be a variable input via a form or cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variables... Help!
try...
hawb = InputBox("Sheet Name") Sheets(hawb).Activate Duncan Graeme wrote: Can anyone help? At the minute I have script that reads: Windows("Ind ot data.xs").Activate Sheets("190906").Select But I want the 190906 to be a variable input via a form or cell. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variables... Help!
or if you want it fixed in a cell...
hawb = Range("A1").Value Sheets(hawb).Activate Duncan Duncan wrote: try... hawb = InputBox("Sheet Name") Sheets(hawb).Activate Duncan Graeme wrote: Can anyone help? At the minute I have script that reads: Windows("Ind ot data.xs").Activate Sheets("190906").Select But I want the 190906 to be a variable input via a form or cell. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variables... Help!
Graeme,
Has this worked for you? Duncan Duncan wrote: or if you want it fixed in a cell... hawb = Range("A1").Value Sheets(hawb).Activate Duncan Duncan wrote: try... hawb = InputBox("Sheet Name") Sheets(hawb).Activate Duncan Graeme wrote: Can anyone help? At the minute I have script that reads: Windows("Ind ot data.xs").Activate Sheets("190906").Select But I want the 190906 to be a variable input via a form or cell. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variables... Help!
Duncan
Help much appreciated. Suggested fix has worked. Ta. Graeme "Duncan" wrote: Graeme, Has this worked for you? Duncan Duncan wrote: or if you want it fixed in a cell... hawb = Range("A1").Value Sheets(hawb).Activate Duncan Duncan wrote: try... hawb = InputBox("Sheet Name") Sheets(hawb).Activate Duncan Graeme wrote: Can anyone help? At the minute I have script that reads: Windows("Ind ot data.xs").Activate Sheets("190906").Select But I want the 190906 to be a variable input via a form or cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if 2 variables | Excel Discussion (Misc queries) | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| Variables | Excel Programming | |||
| Variables | Excel Programming | |||
| Variables | Excel Programming | |||
Linear Mode
