VBA - Search worksheets and find current month

[Simbo2015]

Hi, I'm hoping someone may be able to help.

Is there a way in VBA to search the worksheets (which are labelled jan, feb, mar.....etc) and open/select the one which matches the current month?

Would I need a verification cell which has the current month in or can it all be done in VBA?

Thanks in advance.

 

[AlphaFrog]

Try something like this...

Sheets(Format(Date, "mmm")).Select

If run today, it should select a sheet with a tab name Jun.

 

[Simbo2015]

Works a treat.

Much appreciated.

 

[AlphaFrog]

You're welcome. Thanks for the feedback.