Create a Pop up box that prompts for criteria in a macro

[Guest]

I am very good with Access but my boss is using Excel for this particular
project because of the calculation abilities. Can I create a pop up box that
prompts for parameters and shows the rows in the spreadsheet that meet these
criteria.

 

[Ron de Bruin]

Hi Rob

Maybe example workbook 2 in the zip file is what you want ?
It use a data validation dropdown to make it easy
http://www.rondebruin.nl/accessexcel.htm

 

[Guest]

For some reason, my IT department here at work has blocked the website that
you directed me to. I have posted my question again, twice unknowing, but I
thought maybe you could help me with this code.

I have a created the 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!!!

 

[Ron de Bruin]

Hi Rob

I can send you the zip file with the example if you want ?

 

[Guest]

That would be great. My email address is (e-mail address removed)

 

[Ron de Bruin]

Send