combo box format in excel

Question

Hi, I want to format combo boxes as ' 13:30' or ' 6:30' . I want '[H]:mm' format in combo box drop down.

I used below List for combo box;

     6:00

     6:30

     7:00

    ....

      11:30

      12:00

But, n the combo box drop down list,  the format is the number like ' 0.25' 

How can I format the combo box  list like ' [H]:mm' type?

Thanks

Answer 1

HI

I took your sample file from the other post and I added a combobox with the Time.

Have a look at it, you'll need to download it because macros don't run on "One Drive "

Here is the link:

https://onedrive.live.com/?cid=3a2c42285a53958a&authkey=!AO_DXsHdeDhtuko

If that's what you want, the script is in the Userform.

P.S.

If we answer your post, please mark them as "ANSWERED"

Answer 2

You're welcome

Thanks for the feedback, and marking the post Answered.

It's appreciated by everyone when posts are marked

Answer 3

Thank you very much. It worked!!

I appreciated your help.:)

Answer 4

Dear Tobemaster

Can you please elaborate more. Which combo box you are using. (Form controls or activex controls) and in which application like you are using it in Excel Spreadsheet or in VBA. You want the cell format as [H]:mm in Combox or in related cell reference.

If possible, please upload a sample file along with problem and output you required. So that fellow members can understand easily and try to help you at the earliest