User form Default value in text box
in [Programming]
|
Prev: form not opening when started from command line
Next: Delegate constructor compiles in VB.NET, but not in Excel VBA
From: AccessUser777 via OfficeKB.com on 4 Jun 2010 11:05 Hi all. Quick question. I have a user form in excel which has a text box which i want to have the value defaulted to the current date. I've looked at several posting on this site but haven't gotten it to work yet. Any ideas on how to set the text box with the current date as a default value? Any help or direction is appreciated. Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-programming/201006/1
From: Mike H on 4 Jun 2010 11:56
Hi, Try this way Private Sub UserForm_Activate() TextBox1.Text = Date End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "AccessUser777 via OfficeKB.com" wrote: > Hi all. > Quick question. I have a user form in excel which has a text box which i want > to have the value defaulted to the current date. I've looked at several > posting on this site but haven't gotten it to work yet. Any ideas on how to > set the text box with the current date as a default value? Any help or > direction is appreciated. Thanks. > > -- > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/excel-programming/201006/1 > > . > |