MonthView development

d365b

New Member
Joined
Dec 26, 2021
Messages
17
Office Version
  1. 365
Platform
  1. Windows
Hello everyone!

I am trying to develop a MonthView control as Excel 365 64-bit down not support the mscomct2.ocx
I have looked around and put together ideas, such as the strategy to capture a label click I found in the thread below

Userform Label Click problem

However, now I am stuck as all I can do with the label click event is to display one of its properties in a message box. Is there a way to return its caption, for example, to another class (cCalendar) that takes care of putting together the labels and displaying the calendar or to have label_click handler within the cCalendar class?

Many thanks for your suggestions :)
 

Attachments

  • MonthView.png
    MonthView.png
    97.8 KB · Views: 49

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Looks like you're trying to re-invent the wheel.
Do a Google search for "Trevor Eyre Datepicker"
 
Upvote 0
Thanks NoSparks. Yes I saw this DatePicker but the aim is to replace the MonthView I am developing in the UserForm of the Excel Applications I previously built and unfortunately the Trevor Eyre is not very suitable. I will check his code to see if there is something I could reuse.
 
Upvote 0

Forum statistics

Threads
1,223,941
Messages
6,175,537
Members
452,652
Latest member
eduedu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top