| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I prompt the user to select a cell?
Hello,
please can someone help me with the following ... My macro needs to ask the user which worksheet column they want totalled. I could use InputBox to ask them to supply the letter of the column but I would prefer it if they could click on a cell in the column they choose. Eg in response to a macro prompt they click on G4 and the macro then totals the G column. Your help would be appreciated. Cath |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I prompt the user to select a cell?
Cath
'your code here Set srng = Application.InputBox(prompt:= _ "Select G4 or any other cell", Type:=8) 'rest of code to do something with the selection Gord Dibben MS Excel MVP On 19 Dec 2006 15:14:22 -0800, wrote: Hello, please can someone help me with the following ... My macro needs to ask the user which worksheet column they want totalled. I could use InputBox to ask them to supply the letter of the column but I would prefer it if they could click on a cell in the column they choose. Eg in response to a macro prompt they click on G4 and the macro then totals the G column. Your help would be appreciated. Cath |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I prompt a user to update a cell in Excel? | Excel Discussion (Misc queries) | |||
| How do I prompt a user to update a cell value (ie the date)? | Excel Worksheet Functions | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
| Prompt user to select file with default file selected dialog | Excel Programming | |||
Linear Mode
