datetimeformat in userform.textbox 
Author Message
 datetimeformat in userform.textbox

Hello,

I'm looking for de VBA-code which show the 'date' in a textbox with the
datetimeformat "d mmmm yyyy".

Thanks.

Jeroen



Fri, 14 Jun 2002 03:00:00 GMT  
 datetimeformat in userform.textbox
Hi Jeroen,

Try: TextBox1.Text = Format(Date, "d MMMM yyyy")

Hope this helps,
regards,
Astrid
Microsoft Word MVP



Quote:
> Hello,

> I'm looking for de VBA-code which show the 'date' in a textbox with the
> datetimeformat "d mmmm yyyy".

> Thanks.

> Jeroen



Fri, 14 Jun 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Userform: populate textbox with date from another textbox

2. datetimeformat

3. DateTimeFormat Schema setting

4. Basic (!) userform query - greying out of textboxes

5. UserForms, Textboxes & Bookmarks

6. Userforms - populating textboxes

7. Invoking autocorrect from textbox on a userform

8. Greying out textboxes in a userform

9. Focus and textboxes on vba userforms

10. Looping thru Textboxes in Userform

11. Unloading an array to TextBoxes on a UserForm

12. Help with userform/textbox

 

 
Powered by phpBB® Forum Software