Calender in VBA for Excel

[MarkMorrison]

I am trying to create a calender in VBA for Excel (using Forms etc) that, when I click on the date (i.e 20th December) it will display a specific cell in another excel worksheet - is this possible?

Many thanks

[teylyn]

Tach Mark!

Herzlich willkommen im Forum!

Could you possibly explain a bit more? Like, what do you mean by "display a specific cell"? Display where? In the UserForm? What is the connection between the "specific cell" and 20th December?

Maybe you could mock up a workbook with expected results and explain the logic?

You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

Servus