Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 05, 05:44 AM posted to microsoft.public.excel.misc
stephiebrady
 
Posts: n/a
Default Can I display the current date in a text box?

I know how to display the current date in a cell, but can I display it in a
text box? And how would I do that?

  #2   Report Post  
Old December 1st 05, 09:54 AM posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Can I display the current date in a text box?

You would have to have some code to load it, such as

Textbox1.Text = Format(Date,"dd mmm yyyy")

or link the texbox to a cell with the formula =TODAY()

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stephiebrady" wrote in message
...
I know how to display the current date in a cell, but can I display it in

a
text box? And how would I do that?



  #3   Report Post  
Old December 2nd 05, 02:45 PM posted to microsoft.public.excel.misc
stephiebrady
 
Posts: n/a
Default Can I display the current date in a text box?

Thank you!!!

"Bob Phillips" wrote:

You would have to have some code to load it, such as

Textbox1.Text = Format(Date,"dd mmm yyyy")

or link the texbox to a cell with the formula =TODAY()

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stephiebrady" wrote in message
...
I know how to display the current date in a cell, but can I display it in

a
text box? And how would I do that?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
pasting data from a website changes text to date stebro Excel Discussion (Misc queries) 8 August 12th 06 08:39 PM
NETWORKDAYS - Multiple Date Selection Annabelle Excel Discussion (Misc queries) 3 October 4th 05 07:04 PM
How do I extract a date as text not the 1900 reference number Adam Excel Discussion (Misc queries) 3 March 23rd 05 05:04 PM
Excel enters date as a text format Kane Excel Discussion (Misc queries) 3 March 22nd 05 09:20 PM
How do I convert a number formated as a date to text in Excel? BrotherNov Excel Discussion (Misc queries) 5 March 2nd 05 03:51 PM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017