Posted to microsoft.public.excel.programming

Candee[_32_] Candee[_32_] is offline

external usenet poster

Posts: 1

Format data entered with User Form

This is how I format for dates entered in textboxes on userforms.
There's probably a better way, but this works :)

Private Sub txtDate_Exit(ByVal Cancel As MSForms.ReturnBoolean)
txtDate.Text = Format(txtDate.Text, "m/d/yy")
End Sub

hth,
Cande

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying data entered into a form to another workbook	zak	Excel Discussion (Misc queries)	0	December 29th 08 12:14 PM
Date format changes when inputed from user form	Lynz	Excel Discussion (Misc queries)	16	December 13th 08 11:27 PM
sorting worksheets containing both imported data and user entered	leejb	Excel Discussion (Misc queries)	0	August 20th 08 11:13 PM
Excel User Form- Format Proper Case	dpaulos[_3_]	Excel Programming	0	January 27th 04 02:36 AM
Excel User Form- Format Proper Case	dpaulos	Excel Programming	0	January 27th 04 02:02 AM

All times are GMT +1. The time now is 12:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us