Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting userform textbox - help required
Hello All
I have created a command button which when clicked enters the date and time into a textbox on my userform by using a sub - TextBox1.value=Now() My problem is it enters in M/D/YYYY_H:M:S format and, being British, I require D/M/YYYY_H:M:S format. As I could not find a way of altering the date property of the text box I attempted to add TextBox1.Format=D/M/Y_H:M:S into my sub but this only created an error! Could someone please advise on the correct method of acheiving what I equire TIA Kenny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform textbox | Excel Worksheet Functions | |||
Formatting number in a UserForm TextBox | Excel Programming | |||
formatting text in TextBox in UserForm | Excel Programming | |||
Calculating a textbox on a userform | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |