wudhus_kid
New Member
- Joined
- Aug 8, 2007
- Messages
- 31
I'd like a button to insert today's date into a text box. I have this code thus far:
The problem I am having is that this inserts the date in American Format (mm/dd/yyyy)
Is there any way of setting the format of a text box, like the number category property of a cell?
Many Thanks
Alan Pope
Code:
Private Sub CommandButton1_Click()
TextBox1.Value = Date
End Sub
The problem I am having is that this inserts the date in American Format (mm/dd/yyyy)
Is there any way of setting the format of a text box, like the number category property of a cell?
Many Thanks
Alan Pope