ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I display the current date in a text box? (https://www.excelbanter.com/excel-discussion-misc-queries/58123-can-i-display-current-date-text-box.html)

stephiebrady

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?

Bob Phillips

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?




stephiebrady

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?






All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com