Alternative to InputBox

[Tom Ogilvy]

Excel does not support this type of operation. Frank Kabel suggested using
the selectionchange event. You could possibly combine that with the display
of a modeless userform to provide the font and indicate that the next event
would indicate a user selection.

 

[MAS]

I have written my code and it does what I want but I was hoping to tidy it
up with some more intuitive means of input.

Is it is now :

StaffName = Application.InputBox("Click on the Name of the Person
Requesting", _
"Request", , , , , , 8).Value

Very basic inbox comes up.
The user has to click on a cell.
User Clicks on "OK"
The content of the selected cell is processed as a variable.

What I want to do:
Prompt the user to click on a cell
User clicks on Cell
Process the content of the cell as a variable.

It seems so simple but I can't see a way to do what I want.

MAS

 

[SW]

Try this in any sheet

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Target = " & Target
End Sub

Regards
Steve