Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
InputBox | Excel Discussion (Misc queries) | |||
Inputbox with VBA | Excel Discussion (Misc queries) | |||
InputBox | Excel Programming | |||
inputbox help | Excel Programming | |||
inputbox | Excel Programming |