If I invoke the Excel data form on a workheet range, the controls (fields) on the form correctly mirror any formatting on the database range i.e. number format, date format ("dd/mm/yy") etc.,
However if I try to create a custom UserForm the Textbox controls I add to the form are just that "Textboxes"! How can I capture the
contents of the related fields and format them to dates etc. so that they are displayed on the form and written to the worksheet in the desired format?
Any help would be greatly appreciated.
However if I try to create a custom UserForm the Textbox controls I add to the form are just that "Textboxes"! How can I capture the
contents of the related fields and format them to dates etc. so that they are displayed on the form and written to the worksheet in the desired format?
Any help would be greatly appreciated.