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.

--
Regards,
Tom Ogilvy


"MAS" wrote in message
...
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

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

Try this in any sheet

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

Regards
Steve

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"MAS" wrote in message
...
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