how do I prompt the user to select a cell?

  • Thread starter Thread starter cathellisuk
  • Start date Start date
C

cathellisuk

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with macro to find matching data between two worksheets 4
vba to check range of cells and print 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro That doesn't work - Please help 3
If cell value is greater than another cell value, clear contents. 6
conditional formatting for a variable range 1
Prompt User to Select Macro to Run? 1
SELECT PART OF A TEXT IN A CELL 1

Back
Top