By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,060 Members | 1,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,060 IT Pros & Developers. It's quick & easy.

Excel 2003 Userforms Date

P: 1
Hi
when opening a new USERform I would like to display todays date in TextDATE field on form and write if not updated to the worksheet field.

Where does this code have to sit for it to display
Nov 10 '11 #1
Share this Question
Share on Google+
2 Replies


dsatino
100+
P: 393
Not real clear on what you're asking, but if you have a text box that you want to show today's date you simply set the controlsource to Date().
Nov 10 '11 #2

NeoPa
Expert Mod 15k+
P: 31,709
TextDATE would be a control not a field. The worksheet field - I'm guessing - is a reference to an unspecified cell on a worksheet.

Your code and where it goes depends largely on other information you haven't shared with us. Where is your current code that causes the form to be displayed and how is that code invoked? What do you want to see happen with this control on your form?

Without these pieces of information you don't even have a valid question from which to consider an answer.
Nov 12 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.