KestutisTower
New Member
- Joined
- Jun 2, 2022
- Messages
- 23
- Office Version
- 2016
- Platform
- Windows
Hello everyone. Im new to this forum. AND i'm stuck![Man facepalming :man_facepalming: 🤦♂️](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f926-2642.png)
![Grinning face with sweat :sweat_smile: 😅](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f605.png)
I'm creating a userform with two comboboxes ant a textbox. the idea is to retrieve information from a table with data populated via other userform and date is autogenerated.
Combobox1 rowsource is colum "Customer" and Combobox2 rowsource is "Date". What I need to do, is when I input selection in Combobox1 and Combobox2, data to appear in textbox1. As you can see, there are multiple results in some cases. So ... basically I need a VBA code with multiple criteria, to gel multiple results and to show all that in textbox1.
Hope I presented my problem clearly.
All help will be appreciated![Folded hands :pray: 🙏](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f64f.png)
![Man facepalming :man_facepalming: 🤦♂️](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f926-2642.png)
![Grinning face with sweat :sweat_smile: 😅](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f605.png)
I'm creating a userform with two comboboxes ant a textbox. the idea is to retrieve information from a table with data populated via other userform and date is autogenerated.
Customer: | Product: | Date: |
JOHN | TV | 22/05/01 |
LINDA | TV | 22/05/01 |
JOHN | RADIO | 22/05/02 |
LINDA | PC | 22/05/02 |
SUSIE | PC | 22/05/01 |
JOHN | PC | 22/05/01 |
Combobox1 rowsource is colum "Customer" and Combobox2 rowsource is "Date". What I need to do, is when I input selection in Combobox1 and Combobox2, data to appear in textbox1. As you can see, there are multiple results in some cases. So ... basically I need a VBA code with multiple criteria, to gel multiple results and to show all that in textbox1.
Hope I presented my problem clearly.
All help will be appreciated
![Folded hands :pray: 🙏](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f64f.png)