Good evening folk
I am using this code to ensure the combobox converts figures to the HH:MM format, this works very well... however I am also looking for a way for the combobox to also accept letters from a rowsource
can anyone help with this please
Many thanks
JT
Please Login or Register to view this content.
Last edited by JamesT1; 06-10-2019 at 02:44 AM. Reason: Solved
What do you mean by "letters from a rowsource"? If the user enters something other than a time, what is it, and how will you interpret it?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
How are you populating the combobox?
If posting code please use code tags, see here.
Thanks guys
The combobox rowsource is a named range with 2 or 3 digit codes for absences... what I'm looking for is for the user to insert the start time,, or select the code if the person is absent...
The code above I use in other parts so the user just types in the time digits... e.g 0600 and it converts it to the time (HH:MM), 06:00,, however it doesn't work in the boxes with the codes
Many thanks
JT
Last edited by JamesT1; 06-06-2019 at 01:12 PM. Reason: spelling
JT
What's the purpose of the combobox?
Is if for entering a start/end time?
Hi Norie
It is mainly for entering the time,,, and if possible record the absence code...
Cheers
JT
Any chance you could upload a sample workbook?
Click on GO ADVANCED, scroll down and click Manage Attachments.
Thanks Norie
On the attached,,, the combo boxes with the absence codes,, will accept 3 or 4 digit numbers but wont convert to HH:MM. the boxes without the codes will convert the time...
The boxes without the absence codes will not accept them..
What I would like to do is have the boxes accept the codes and convert number digits to HH:MM
many thanks for your help
JT
James
Perhaps you could use something like this to check if the user has selected an absence code rather than entering a time.
PS What do you want to happen when a user selects an absence code?Please Login or Register to view this content.
Is this what you're after ?
This is for the top right combo.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Norie/Bakerman2
Your are both stars,,, both version do what I need...…
Norie,, It just needs to transfer the information to the sheet,, so taking out the message box let it do just that,, many thanks for your help,,
Very much appreciated ,,both
JT
You're welcome and thanks for rep+.
Norie/Bakerman2
Many thanks for your help with this,,, its doing exactly as you guys said it would, I have come across another wee issue with it....
When the Userform is opened after saving the time, I am looking for the text boxes to show the cell contents.. its doing this OK,, however it is changing the times from the HH:MM format and subsequently changing the cell format when its saved again
any further help would be very much appreciated
This seems to work.
Please Login or Register to view this content.
bakerman 2.. once again many thanks for your help,, spot on,,, my sheet now displays everything correctly
many thanks for your valuable assistance,, very much appreciated..
JT
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks