Posted to microsoft.public.excel.programming

ryguy7272

external usenet poster

Posts: 2,836

Get a date to display in date format on a UserForm

How can I get a date to display in date format on a UserForm? I thought it
would be something simple, such as the following:
If ComboBox1.Text < "" Then
ComboBox1.Value = Format(ComboBox1.Value, "mm/dd/yyyy")
End If
However, I just see 39539 in the ComboBox when I really want to see 4/1/2008.

Thanks in advance.
Ryan--

--
RyGuy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Date Format in a Userform Listbox	Joel	Excel Programming	0	February 21st 07 02:17 PM
Date Value in wrong format on userform	Corey	Excel Programming	19	November 7th 06 01:06 PM
Date Format in Userform	Peter1999	Excel Programming	3	June 8th 06 04:32 PM
Date format in userform	cutsygurl	Excel Programming	3	April 19th 06 09:44 AM
Date format from UserForm	SOS[_39_]	Excel Programming	3	February 16th 06 02:22 PM

All times are GMT +1. The time now is 08:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us