Set default date format of all text boxes on a user form

[KAPearson]

I've made a userform with lots of text boxes. is there a way to set the default date format on each box ideally from the VBA editor but by VBA if not. Bare in mind that I'd need some of the text boxes to remain as text not dates. Thank you.

[richiev4]

I'm having the same problem. I have dates in my spreadsheet that are formatted dd/mm/yyyy but on the form they show up as mm/dd/yyyy, Please does someone have a fix/answer?

[Leith Ross]

Hello KAPearson,

There is no method built in to the VBA editor to do what you asked. It will have to be done using VBA. If you post your workbook then I can write the code you need to do this easily. The process involves Subclassing the TextBox controls to automatically format the date. This is a little more complex approach but is much easier and faster that copying code into each TextBox.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[BigBas]

Leith,

I'd also be interested in seeing your approach. If KAPearson doesn't upload a file, could you possibly still show us the approach using a mock file?

Thanks,
Bas

[Leith Ross]

Hello BigBas,

Certainly.