Posted to microsoft.public.excel.programming

Trefor

external usenet poster

Posts: 201

Userform formatting

I have a UserForm textbox point to a cell on a sheet. The cell is date
formated to dd-mmm-yyyy but the test box seems to default to m/d/yyyy unless
m 12 then the format changes to d/m/yyy. Is it possible to change the date
format on the Userform or make it obey the sheet formatting?

--
Trefor

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
Conditional formatting and userform	jknapp1005	Excel Discussion (Misc queries)	0	May 6th 09 04:53 PM
Formatting userform textbox - help required	Kennyatwork	Excel Programming	3	February 6th 04 04:58 PM
Formatting number in a UserForm TextBox	John Pierce	Excel Programming	3	January 26th 04 04:57 PM
Userform/Cell formatting	Todd Huttenstine	Excel Programming	2	September 28th 03 11:16 PM
Userform Formatting	Todd Huttenstine	Excel Programming	7	September 28th 03 09:36 PM

All times are GMT +1. The time now is 02:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us