Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textbox returns changeable date
I'm trying to get a userform textbox to show the current date when the form is loaded. However, the user still has to be able to edit it to a different date if they need to.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textbox returns changeable date
I'm trying to get a userform textbox to show the current date when
the form is loaded. However, the user still has to be able to edit it to a different date if they need to. Sooo.., what's your question? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textbox returns changeable date
Is there some mode that the userform textbox needs to be in for the user to be able to change it even if there is already a date in the textbox?
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textbox returns changeable date
Is there some mode that the userform textbox needs to be in for the
user to be able to change it even if there is already a date in the textbox? Obviously.., you haven't run your userform have you? A textbox is a user input control and so doesn't need any special treatment to be used as such. Run the userform! Try it out! Sub Userform_Initialize() Me.TextBox1.Text = Date 'today's date End Sub When it displays, change the textbox contents however you like! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform textbox returns changeable date
You're right. Sorry, bit of an amateur here.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Format for Userform TextBox | New Users to Excel | |||
date entry in userform textbox | Excel Programming | |||
Qn: Date Format in TextBox in UserForm? | Excel Programming | |||
Date Calculation in UserForm TextBox | Excel Programming | |||
Userform Textbox - Date Problem | Excel Programming |