User form Default value in text box

  • Follow


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

0
Reply AccessUser777 6/4/2010 3:05:38 PM

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
> 
> .
> 
0
Reply Utf 6/4/2010 3:56:24 PM


1 Replies
1590 Views

(page loaded in 0.021 seconds)


Reply: