Hi. I can't seem to find a solution to this. I need to enter a value from a userform textbox (or to as well) to a sheet. When entering on the userform, it works fine if I type "0:1:17" as 1 minute and 17 seconds but I only want to type "1:17" and have this entered to a cell on a sheet as the value meaning 1 minute and 17 seconds. However, everything I try to do fails. Mostly the entered result on the sheet turns out to be 17:00. Any ideas how to work around this?
Just to clarify as the above seems confusing. I want to enter a value similar to 1:17 representing 1 minute and 17 seconds to a userform text box and for this value (upon pressing a command button) to a cell on a sheet as 1:17 (meaning minutes and seconds)
Just to clarify as the above seems confusing. I want to enter a value similar to 1:17 representing 1 minute and 17 seconds to a userform text box and for this value (upon pressing a command button) to a cell on a sheet as 1:17 (meaning minutes and seconds)