LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
InputBox GeorgeJ Excel Discussion (Misc queries) 5 July 12th 07 01:20 AM
Inputbox with VBA Jeff Excel Discussion (Misc queries) 3 January 19th 06 05:18 PM
InputBox Hargrove Excel Programming 2 April 29th 04 07:43 PM
inputbox help lothario[_60_] Excel Programming 4 December 7th 03 12:26 AM
inputbox Lawson Excel Programming 2 October 7th 03 08:58 PM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"