imakeyoursundae
New Member
- Joined
- Mar 20, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi all, I'm new to VBA so I would like some guidance to the following problem.
I have currently created a UserForm in Excel where I can search and update data in several sheets.
But I was wondering if it would be possible to create something (a button which leads to a new Userform) to print or export a list of all entries where something (like a date) is missing. I would like to create a combobox of my columnheads so that I can define in which column the filter should work.
I'm also using a ListBox in my original UserForm to define the sheet (actWsh) on which should be worked to search/update since this is important to my data.
(e.g. filter: Date < choices: *does not contain data *date: dd/mm/yyyy)
And once that filter has been defined, I want it to give the choice to export the list in xlsx/PDF/etc.
I have currently created a UserForm in Excel where I can search and update data in several sheets.
But I was wondering if it would be possible to create something (a button which leads to a new Userform) to print or export a list of all entries where something (like a date) is missing. I would like to create a combobox of my columnheads so that I can define in which column the filter should work.
I'm also using a ListBox in my original UserForm to define the sheet (actWsh) on which should be worked to search/update since this is important to my data.
(e.g. filter: Date < choices: *does not contain data *date: dd/mm/yyyy)
| Filter | Combobox of columnheads |
| Choices | * Option 1: does not contain data |
| * Option 2: 20/03/2022; Anna; Anna123 etc. |
And once that filter has been defined, I want it to give the choice to export the list in xlsx/PDF/etc.
