fboehlandt
Active Member
- Joined
- Sep 9, 2008
- Messages
- 334
Hi everyone,
I have a worksheet with two dropdown menus. The first contains months from January to December, the second contains years from 2011 to 2025. Upon opening the worksheet, I would like the entries selected to match to the month and year of the current system date. I know this is relatively easy to implement but, unfortunately, the macro recorder is of no help here. Could someone please indicate how to refer to dropdown menus in an Excel worksheet and how to select a specific entry from the dropdown menu?
I have a worksheet with two dropdown menus. The first contains months from January to December, the second contains years from 2011 to 2025. Upon opening the worksheet, I would like the entries selected to match to the month and year of the current system date. I know this is relatively easy to implement but, unfortunately, the macro recorder is of no help here. Could someone please indicate how to refer to dropdown menus in an Excel worksheet and how to select a specific entry from the dropdown menu?