MarioMagnus
New Member
- Joined
- Jul 8, 2021
- Messages
- 14
- Office Version
- 2019
- Platform
- MacOS
Hi,
I need help with a userform with two comboboxes.
The date in the minisheet is an example and the formula that I use workes within the sheet, but I need to bring this into a userform.
I select the name based on the column 1 and when a available name is selected, I need to run the formula to bring all available dates for the actually month in the combobox two.
I hope I could explain what I need. I hope you can help me with that problem.
Thanks, Mario.
I need help with a userform with two comboboxes.
The date in the minisheet is an example and the formula that I use workes within the sheet, but I need to bring this into a userform.
I select the name based on the column 1 and when a available name is selected, I need to run the formula to bring all available dates for the actually month in the combobox two.
I hope I could explain what I need. I hope you can help me with that problem.
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Name | Datum | Monat | |||||||||
2 | Yanik | 5/12/21 | 5 | |||||||||
3 | Noémie | 5/13/21 | 5 | |||||||||
4 | Yanik | 5/13/21 | 5 | |||||||||
5 | Noémie | 5/14/21 | 5 | Noémie | 5 | 13/05/2021 | ||||||
6 | Yanik | 5/14/21 | 5 | 14/05/2021 | ||||||||
7 | Noémie | 5/15/21 | 5 | 15/05/2021 | ||||||||
8 | Yanik | 5/15/21 | 5 | 16/05/2021 | ||||||||
9 | Noémie | 5/16/21 | 5 | 17/05/2021 | ||||||||
10 | Yanik | 5/16/21 | 5 | 18/05/2021 | ||||||||
11 | Noémie | 5/17/21 | 5 | 20/05/2021 | ||||||||
12 | Yanik | 5/17/21 | 5 | |||||||||
13 | Noémie | 5/18/21 | 5 | |||||||||
14 | Yanik | 5/18/21 | 5 | |||||||||
15 | Noémie | 5/20/21 | 5 | |||||||||
16 | Yanik | 5/20/21 | 5 | |||||||||
17 | Yanik | 5/26/21 | 5 | |||||||||
18 | Noémie | 6/2/21 | 6 | |||||||||
19 | Yanik | 6/2/21 | 6 | |||||||||
20 | Yanik | 6/4/21 | 6 | |||||||||
21 | Noémie | 6/11/21 | 6 | |||||||||
22 | Yanik | 6/11/21 | 6 | |||||||||
23 | Noémie | 6/12/21 | 6 | |||||||||
24 | Yanik | 6/12/21 | 6 | |||||||||
25 | Noémie | 6/13/21 | 6 | |||||||||
26 | Yanik | 6/13/21 | 6 | |||||||||
27 | Sophie | 6/22/21 | 6 | |||||||||
28 | Noé | 6/22/21 | 6 | |||||||||
29 | Noémie | 6/23/21 | 6 | |||||||||
30 | Yanik | 6/23/21 | 6 | |||||||||
31 | Yanik | 6/24/21 | 6 | |||||||||
32 | Lars | 6/24/21 | 6 | |||||||||
33 | Yanik | 6/28/21 | 6 | |||||||||
34 | Noémie | 6/29/21 | 6 | |||||||||
35 | Yanik | 6/29/21 | 6 | |||||||||
36 | Noémie | 7/8/21 | 7 | |||||||||
37 | Yanik | 7/8/21 | 7 | |||||||||
38 | Yanik | 7/9/21 | 7 | |||||||||
39 | Noémie | 7/9/21 | 7 | |||||||||
40 | Noémie | 7/10/21 | 7 | |||||||||
41 | Yanik | 7/10/21 | 7 | |||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J5:J38 | J5 | {=IFERROR(INDEX($B$2:$B$51, SMALL(IF(COUNTIF($G$5, $A$2:$A$51)*COUNTIF($H$5, $C$2:$C$51), ROW($A$2:$C$51)-MIN(ROW($A$2:$C$51))+1), ROW(A1)), COLUMN(A1)),"")} |
Thanks, Mario.