I have a created a macro that selects specific records based on the
criteria
in a cell. I would like to link that cell to a pop up box and have the
box
popup when I click on a toolbar command. I created the toolbar but I
don't
know how to write the macro that would have a box that is linked to the
cell
on the worksheet and after the user enters the criteria in the cell to
run
the macro based on the link to the popup box. I would like for the the
user
to enter the criteria in the pop up box, that criteria populates a cell
in
the worksheet and the macro runs from there. I believe Tom gave me the
code
but I must have copied it wrong. Please help!!!


--
Darius
------------------------------------------------------------------------
Darius's Profile: http://www.excelforum.com/member.php...o&userid=32079
View this thread: http://www.excelforum.com/showthread...hreadid=518324

Step 1: Click a button to show a box
Step 2: User enters data into box
Step 3: User's data from box is entered to a cell on the sprdsht
Step 4: Another macro processes the information in that cell

Is that correct? If yes, then this code could do it for you. Note
that some lines have an apostrophe, which is a user note (the compiler
ignores everything on the line after the apostrophe).

Sub Get_User_Input()
Dim Response

Response = InputBox("Please enter data:") 'get user input
Range("a10").Value = Response 'apply that input to a cell: change this
from a10 to your cell address
MyMacro 'call the other macro: change "MyMacro" to the actual name of
the macro that should run
End Sub