Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In a UserForm I've got a TextBox asking for an amount of time (hours
and minutes). It could be negative. If the user wants to enter a negative date, I want them to be able to just enter, for example: -3:04, -10:53, etc. I'm in 1904 mode. My code for this value is: Worksheets("Leave").Range("K5").Value = UserForm1.TextBox3.Value I've tried inputting times like this: -3:04 and this: -"3;04", but neither will do. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
match one column with dates to several colums with dates, copy pas | Excel Programming | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
Toggle a range of Julian dates to Gregorian Dates and Back | Excel Programming | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions |