MonthView DatePicker default to current date

Hello gods of Excel Universe!https://www.mrexcel.com/forum/images.../icon_cool.gif

I have been trying now for a month figuring this out but to no avail. Also i have searched the forums and found none related to my issue.

Basically in my userform,i just want my MonthView date picker to default to the current month/date, although i have the "Today" date displayed at the bottom of the monthview calendar, the actual month view is from the past and i'd really want the current one to show.

Apparently you cannot delete the date in "Value" property. It would not accept number zero as well or any word that i have tried my luck such as "Today" or "Now". Help please!

Thanks for your time!https://www.mrexcel.com/forum/images...icon_smile.gif

Kindly post what you have tried. The workbook is preferable if it does not contain sensitive data.

Quote:

---

Originally Posted by austenr

Kindly post what you have tried. The workbook is preferable if it does not contain sensitive data.

---

Sorry i have not posted details on the form, here it is:

Attachment 24248

As you can see on the monthview, May1 is highlighted or in default. I wanted May21 to be the default which is the current date.
I tried deleting the input value in its property "Value" but it would not.

Attachment 24249

This is the code i have for the MonthView:

Code:

---

Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
    On Error Resume Next
    TextBox1.Value = DateClicked
    Sheet1.Range("C3").Value = DateClicked
End Sub

---

Hope those details are sufficient.

Hi KarlRadaza!
Not sure.

Code:

---

Private Sub UserForm_Initialize()
    MonthView1.Value = Date
End Sub

---

which calender control are you using
Have tried it on MSCAL.OCX and everything works as it should !
Rob