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