|
Create a Pop up box that prompts for criteria in a macro
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. |
Create a Pop up box that prompts for criteria in a macro
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. |
Create a Pop up box that prompts for criteria in a macro
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. |
Create a Pop up box that prompts for criteria in a macro
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. |
Create a Pop up box that prompts for criteria in a macro
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. |
| All times are GMT +1. The time now is 12:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com