UserForm Controls -revisited

Gastank · Feb 21st, 2002, 09:47 AM

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.

Mudface · Feb 21st, 2002, 12:13 PM

If your date is in say A1, then you could try something like-

TextBox1.Text = Format(Cells(1,1), "dd/mm/yyyy")

Try looking up the format function in the Help files for other formats.

[ This Message was edited by: Mudface on 2002-02-21 11:26 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 09:47 AM	#1
Gastank New Member Join Date: Feb 2002 Posts: 25	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.

Feb 21st, 2002, 12:13 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	If your date is in say A1, then you could try something like- TextBox1.Text = Format(Cells(1,1), "dd/mm/yyyy") Try looking up the format function in the Help files for other formats. [ This Message was edited by: Mudface on 2002-02-21 11:26 ]