| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start up macro to get a number from user
In the old days I used to use \0 macros and {GETNUMBER} or {GETLABEL} in
Lotus to get a number from a user having asked a question like "Please input Month number for report" and it would put a number into a cell to drive indexes and Vlookup and hlookup tables. Any one have any ideas on how to do this in VBA please - this is a dark street for me! Thanks Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start up macro to get a number from user
In it's simplest form ...
Sub AskUser() Range("A1").Value = InputBox("Please input month number for report") End Sub PaulB wrote: In the old days I used to use \0 macros and {GETNUMBER} or {GETLABEL} in Lotus to get a number from a user having asked a question like "Please input Month number for report" and it would put a number into a cell to drive indexes and Vlookup and hlookup tables. Any one have any ideas on how to do this in VBA please - this is a dark street for me! Thanks Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start up macro to get a number from user
To update automatically on opening the file ...
Sub Auto_Open() Range("A1").Value = InputBox("Please input month number for report") End Sub Alan wrote: In it's simplest form ... Sub AskUser() Range("A1").Value = InputBox("Please input month number for report") End Sub PaulB wrote: In the old days I used to use \0 macros and {GETNUMBER} or {GETLABEL} in Lotus to get a number from a user having asked a question like "Please input Month number for report" and it would put a number into a cell to drive indexes and Vlookup and hlookup tables. Any one have any ideas on how to do this in VBA please - this is a dark street for me! Thanks Paul |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Start up macro to get a number from user
Thanks for that Alan.
But being a complete novice at this new way of doing macros - where do I write this please? Thanks Paul "PaulB" wrote: In the old days I used to use \0 macros and {GETNUMBER} or {GETLABEL} in Lotus to get a number from a user having asked a question like "Please input Month number for report" and it would put a number into a cell to drive indexes and Vlookup and hlookup tables. Any one have any ideas on how to do this in VBA please - this is a dark street for me! Thanks Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Start Excel without user profile | Setting up and Configuration of Excel | |||
| How do I get User Form to run at start up? | Excel Programming | |||
| start a macro or procedure based on user putting an x in a cell | Excel Discussion (Misc queries) | |||
| Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
| Place a User Form on Start Up | Excel Programming | |||
Linear Mode
