ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Condition form (https://www.excelbanter.com/excel-programming/396423-condition-form.html)

Daniel

Condition form
 
Hi
I made several worksheets in a workbook which retrieve data from network
database and each worksheet has its own query.
Now, because of so many data, how can I limit to recent date and it should
apply to all worksheets?
May be I have to move to Excess which has form, have not seen form in Excel
Thanks
Daniel

Halim

Condition form
 
Daniel,

You can use Excel UserForm which you can add procedure and controls on it.

Try to open by pressing Alt+F11

Then add Userform to your project.

--
Regards,

Halim



"Daniel" wrote:

Hi
I made several worksheets in a workbook which retrieve data from network
database and each worksheet has its own query.
Now, because of so many data, how can I limit to recent date and it should
apply to all worksheets?
May be I have to move to Excess which has form, have not seen form in Excel
Thanks
Daniel



All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com