Title Case

Have looked at Title Case as you suggested, but still can't figure out how to format the textbox so that the format is December 2024. Only this textbox should display the above format

mmmm yyyy

Format

I Have tried mmmm yyyy and it returns december 2024. I  want it to be December 2024 med a capital D

It should be capitalized unless you have some other format on there.

The Swedish setting is to show months in lowercase

This is how it shows

If your Regional settings default to the months in lowercase, then you'll have to use another function to capitalize that letter. You can either grab the left one character or use a proper case, or however else you want to do it.

Need to be explained how to do it. What is the easiest way to fix this?

StrConv is covered in Change Case

Also looked at Change Case but still don't understand how to enter it in VBA, could you pls show me the code.

The image below shows an example using StrConv.

Thank you for your reply,
In the course, we started by creating the DatePicker Form, which must first be opened. Next, a button was made in DatePicker to open MonthlyCalendarF. Today I first opened DatePickerF but did not click the Open Calendar button. I Opened the MonthlyCalendarF in the menu on the left side andthe Calendar was opened  with December 2024 in capital letters, what could be the reason? Closed everything down and tried the Open Calendar button in the DatePickerF and the december in lowercase again. Don't understand how it happens, but it doesn't matter, I made a new button and everything works as it should.