Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in a listbox months can be selected. When opening, or change worksheets previous month to the current month should be displayed and selected. In the current month of June that would be May. The problem is, that Month is in text format. Do you have any idea? Thanks for help.
Regards Stefan
See attached. I have done it for your second sheet.
=Month(AddMonths(Today(),-1))
Create a numerical month (or a date using monthstart) field in the script and use that to make the selection in.
See attached. I have done it for your second sheet.
=Month(AddMonths(Today(),-1))
Thanks for your help.