Display previous month in a listbox

[Anonymous]

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

[Gysbert_Wassenaar]

Create a numerical month (or a date using monthstart) field in the script and use that to make the selection in.

[tresesco · Accepted solution]

See attached. I have done it for your second sheet.

=Month(AddMonths(Today(),-1))

[Anonymous]

Thanks for your help.