Alternative to InputBox
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
|