Combo Box date format also to accept text

**nods** · 11-18-2010, 09:36 AM

Hi I have a form with several combo boxes. The combo boxes are programmed to only accept a time format from the drop down list. But i alse have to alow the user to select either start or finish as a text option.

the code I have so far is

Please Login or Register  to view this content.

I have added the text options to the drop down, but when they are selected the program crashes and foes into debug mode. Does anyone know of a way to prevent this. The only text I want the user to select is start or finish.

Many thanks
Nods

**romperstomper** · 11-18-2010, 10:26 AM

What error are you getting and where?

**nods** · 11-18-2010, 11:24 AM

The user has a list to select from:

Start
00:00
00:15
00:30

If the user slects start it breaks and goes into debug mode because it isn't in the hh:mm format.

My question is is there a way of being able to set a combo box to display the hh:mm format and the word start?

Many thanks

**romperstomper** · 11-18-2010, 11:40 AM

I repeat, What error are you getting and where?

**nods** · 11-18-2010, 12:18 PM

I'm not in front of the work book but was on this peice of code bin the change control of the combo box. It is because it is set to hh:mm format I need it to be able to also accept the word 'Finish'.

Please Login or Register  to view this content.

**romperstomper** · 11-18-2010, 12:39 PM

That code should not cause an error for text.

**nods** · 11-18-2010, 12:49 PM

Apologies, it broke to the debug when I was trying this peice of code with the error "type mismatch."

Please Login or Register  to view this content.

With out the "Finish" it just displays 00:00 when Finish is selected.

Kind regards

Nods

**romperstomper** · 11-18-2010, 01:12 PM

"Finish" is not a valid format code, and you can't supply two format codes. It also didn't appear in any of the code you posted!
If you are supplying the list to the combo, I suggest you put the two text values first (or last) and then check the listindex before formatting the value, though I'm not entirely sure why you need to format the values anyway.

**nods** · 11-18-2010, 01:16 PM

If I don't Format the values as time they just appear as decimal numbers. The text field is already in the list index and appears in the drop down menu on the combobox, it is just that when the text field is selected it is displayed as 00:00.

**romperstomper** · 11-18-2010, 03:53 PM

Is your combobox bound to the worksheet using controlsource and/or rowsource?

**nods** · 11-18-2010, 05:28 PM

It is bound using row source!

**romperstomper** · 11-18-2010, 05:35 PM

Don't use the RowSource. Assign the range's value to the list property of the combo at runtime (Initialize event of the form).

**nods** · 11-18-2010, 06:18 PM

Thanks I have look at that forum. It looks like i would need to write the list in the event for all combo boxes. I have alot of comboboxes and the list is also long.

would be a hell of a lot of code.

**nods** · 11-18-2010, 06:26 PM

Just for inforamtion I have solved the problem with the below code.

Thanks for your help.

Please Login or Register  to view this content.

Combo Box date format also to accept text

LinkBack

Thread Tools

Rate This Thread

Display

Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Re: Combo Box date format also to accept text

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions