Select Case Statement

Hi all,

I have 13 sheets in a workbook: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov , Dec and Macros (the sheet with the message that macros must be enabled in order to use the workbook). I need the workbook to open on the sheet relative to the current month. For example, when I open the workbook today, it should open on the May sheet.

This is my first solo try at using the Select Case Statement, and I can’t get it to work.

I have:

Please Login or Register  to view this content.

Can someone please help me with it.

Thank you,
Gos-C

It should be like this

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Or you could use

Please Login or Register  to view this content.

VBA Noob

Thanks all

Works fine! (One never really learns to drive until he/she is alone in the vehicle.)

Appreciate your generous support.

Gos-C

Hi all,

I am trying to modify the earlier code to have the curser in the correct position for the next entry each time a user opens the workbook, but I can’t get it to work.

The curser should be in the first empty cell (row 5:104) in the correct column (according to the week of the month) and on the current month’s sheet:

Week 1 - column E
Week 2 – column AB
Week 3 – column AY
Week 4 - column BV
Week 5 – column CS

I tried the following code:

Please Login or Register  to view this content.

It is not working. Any help, please?

Thank you,
Gos-C

Hi all,

I finally figured it out - even though it's probably not the most efficient:

Please Login or Register  to view this content.

Thank you,
Gos-C

One last echo:

Please Login or Register  to view this content.

Hi protonLeah,

Thank you very much for the advanced code.

I changed:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

because summary data is further down the sheet.

Regards,
Gos-C

Hi all,

Here is an updated version. It also scrolls the columns so that, on opening the workbook, the current range of the worksheet always appears in the left of the window.

Please Login or Register  to view this content.

Regards,
Gos-C

here's another way

Please Login or Register  to view this content.

Thank you, royUK. Can you please mark this "Solved."

Gos-C