| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format userform text box
how can you format a userform textbox to display time ? i have set the string as time format ???? how do i do this ? -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=560575 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format userform text box
what string?
just use Format(TextBox1.Text,"hh:mm:ss") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Zygan" wrote in message ... how can you format a userform textbox to display time ? i have set the string as time format ???? how do i do this ? -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=560575 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format userform text box
sorry to sound completely newb but hay, i have this code (not all of it but to the point) "indate" is a textbox in the userform Private Sub UserForm_Activate() datein = Sheets("sheet1").Range("a2") indate.Text = datein End Sub where do i put your code ???? if i place it anywhere in this code it errors ???? -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=560575 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format userform text box
Private Sub UserForm_Activate()
datein = Sheets("sheet1").Range("a2") indate.Text = Format(datein,"hh:mm:ss") End Sub If the cell is already formatted as time, you could use Private Sub UserForm_Activate() indate.Text = Sheets("sheet1").Range("A2").Text End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Zygan" wrote in message ... sorry to sound completely newb but hay, i have this code (not all of it but to the point) "indate" is a textbox in the userform Private Sub UserForm_Activate() datein = Sheets("sheet1").Range("a2") indate.Text = datein End Sub where do i put your code ???? if i place it anywhere in this code it errors ???? -- Zygan ------------------------------------------------------------------------ Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423 View this thread: http://www.excelforum.com/showthread...hreadid=560575 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
| zip codes not being saved as text in CSV format | Excel Discussion (Misc queries) | |||
| insert text conditionally and format | Excel Discussion (Misc queries) | |||
| Format Number to Text | Excel Worksheet Functions | |||
| Problem with wrap text format | Excel Worksheet Functions | |||
Linear Mode
