I now have to use the cloud version of Office 365 which no longer supports the DatePicker tool. Consequently any file I open that used this tool fails as the VBA code cannot find that tool. I have decided to create a new form and to merge details into a single worksheet. However, I still need to be able to input and upload date information into / from the database using the user form.
I have custom formatted the target cells in the database to display the date in dd,mmmm,yyyy format and now need to be able to input and receive date information in the user form in a fixed method so that data will be handled and displayed correctly in the user form.
I am considering using a text box to input and display the information in the user form as there are no suitable calendars for Office 365
The user form would use dd/mm/yy as the input and display format but I need to understand how to get the textbox to force six digits to be displayed with a "/" between numerics 2 & 3 and 4 & 5. (Perhaps After_Update can be used but I need the text box to receive a leading zero for each element, where necessary, including at input.
Concatenating 3 separate text boxes might work but would need to be able to work in reverse (I.e. call back from the database..
Any help or suggestions would be gratefully accepted.
Please note that I have tried other suggestions to download calendars however, as the version of office is not stored on my device I cannot copy such files into office.
I have custom formatted the target cells in the database to display the date in dd,mmmm,yyyy format and now need to be able to input and receive date information in the user form in a fixed method so that data will be handled and displayed correctly in the user form.
I am considering using a text box to input and display the information in the user form as there are no suitable calendars for Office 365
The user form would use dd/mm/yy as the input and display format but I need to understand how to get the textbox to force six digits to be displayed with a "/" between numerics 2 & 3 and 4 & 5. (Perhaps After_Update can be used but I need the text box to receive a leading zero for each element, where necessary, including at input.
Concatenating 3 separate text boxes might work but would need to be able to work in reverse (I.e. call back from the database..
Any help or suggestions would be gratefully accepted.
Please note that I have tried other suggestions to download calendars however, as the version of office is not stored on my device I cannot copy such files into office.
