User form Default value in text box

  • Thread starter AccessUser777 via OfficeKB.com
  • Start date
A

AccessUser777 via OfficeKB.com

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.
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No text box in word 2016 0
Word OLE to check spelling in text box 1
Clearing combo boxes and a text box 2
Link a text box based on drop down box with four options MS Word 365 0
Crating User Form to Add Names 1
OLE Word spelling 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Dynamic Naming of Form Button 3

Top