| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Userforms Textbox query
Hi I have a textbox which uses a date value in a cell from the spreadsheet. At the moment it shows the value of the cell as m/d/yy how do I get it to view dd/mm/yy? -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=414234 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Userforms Textbox query
Try using a textbox from the drawing toolbar rather than from the control
toolbox toolbar. -- Regards, Tom Ogilvy "funkymonkUK" wrote in message ... Hi I have a textbox which uses a date value in a cell from the spreadsheet. At the moment it shows the value of the cell as m/d/yy how do I get it to view dd/mm/yy? -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=414234 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Userforms Textbox query
unfortunately I cannot as I am using a userform. -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=414234 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Userforms Textbox query
unfortunately I cannot as I am using a userform -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=41423 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Userforms Textbox query
Now I see that in the subject. another example of why it is best to include
all pertinent information in the body. Private Sub Textbox1_AfterUpdate() Textbox1.Text = format(Textbox1.Text,"dd/mm/yy") End Sub You might have to experiment with other textbox events to see which works best. -- Regards, Tom Ogilvy "funkymonkUK" wrote in message ... unfortunately I cannot as I am using a userform. -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=414234 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| textbox query | Excel Discussion (Misc queries) | |||
| Textbox Query | Excel Programming | |||
| textbox query | Excel Programming | |||
| Userforms - Display result of a calculation in a textbox | Excel Programming | |||
| Creating Userforms and textbox numbers | Excel Programming | |||
![funkymonkUK[_69_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
