View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MAS MAS is offline
external usenet poster
 
Posts: 18
Default 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