tracyms
asked on
User Form Time Picker
I've tweaked some code for a pop up time picker I found here:
https://www.experts-exchange.com/questions/24868820/Userform-Time-question.html
I'd like to have the time picker "remember" the value in the cell if I double click on it. Currently, I can change the time and it stays in the cell but if double click the cell again, it defaults back to 8:00 AM. In other words, if I change the time to 7:00 AM and double click the same cell, I want it to say 7:00 AM.
I've attached an example file. Thank you.
UserForm-Time-Question.xls
https://www.experts-exchange.com/questions/24868820/Userform-Time-question.html
I'd like to have the time picker "remember" the value in the cell if I double click on it. Currently, I can change the time and it stays in the cell but if double click the cell again, it defaults back to 8:00 AM. In other words, if I change the time to 7:00 AM and double click the same cell, I want it to say 7:00 AM.
I've attached an example file. Thank you.
UserForm-Time-Question.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I gave the first posted solution extra points since he was first. I hope this seems fair to you both. Thanks again!
ASKER
Here is my new question for the date picker:
https://www.experts-exchange.com/questions/28420493/Date-Picker-Form.html
https://www.experts-exchange.com/questions/28420493/Date-Picker-Form.html
ASKER
DateCombos.xlsm