Date Format in UserForm textbox.

shahzad4u_ksa@yahoo.com

Guest

Posts: n/a

6th Jul 2007

Hi,

I have a userform with many text boxes. in Date textbox I want to
write a date like

25 Aug 07 and when I press enter then the date convert to 25 August
2007 in userform. and also it show in worksheet like 25 august 2007.

I am not much experienced in Excel VBA but I am learning.... pls
help me about the procedure for the above problem.

Thanks in advance.

Shahzad
Madinah

« Macro copying an array and pasting to a Word bookmark | Match() how to workaround identical Lookup_values »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Format for Userform TextBox	John Calder	Microsoft Excel New Users	4	29th Jul 2009 10:19 PM
Need A date Mask format for a Textbox on UserForm	soibien@gmail.com	Microsoft Excel Misc	2	4th Nov 2007 02:27 AM
Format TextBox on UserForm	=?Utf-8?B?cnlndXk3Mjcy?=	Microsoft Excel Programming	7	5th Aug 2007 03:46 PM
UserForm including TextBox with date (UK format)	John Elink	Microsoft Excel Programming	2	1st Dec 2004 09:02 AM
Qn: Date Format in TextBox in UserForm?	Michael Vaughan	Microsoft Excel Programming	1	23rd Aug 2004 10:03 AM