About Us

Ron de Bruin

Send

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Rob" wrote in message ...
That would be great. My email address is

"Ron de Bruin" wrote:

Hi Rob

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Rob" wrote in message ...
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" wrote:

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Rob" wrote in message ...
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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create macro to filter on multiple criteria	csdjj021191	Excel Worksheet Functions	7	October 3rd 06 01:52 PM
How to disable macro prompts for OK in Excel?	Austin	Excel Discussion (Misc queries)	8	May 10th 06 08:54 PM
Macro prompts user to run macro?	miwarren[_7_]	Excel Programming	5	October 20th 05 02:43 PM
How can I suppress prompts during macro run?	Andorv	Excel Discussion (Misc queries)	2	October 19th 05 12:37 PM
Getting rid of Prompts in a macro	Duncan J	Excel Programming	5	February 12th 04 07:46 AM

Menu

About Us