Share via

combo box format in excel

Anonymous
2014-05-01T16:42:58+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2014-05-02T14:45:08+00:00

    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"

    Was this answer helpful?

    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Anonymous
    2014-05-02T16:17:55+00:00

    You're welcome

    Thanks for the feedback, and marking the post Answered.

    It's appreciated by everyone when posts are marked

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2014-05-02T16:05:56+00:00

    Thank you very much. It worked!!

    I appreciated your help.:)

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2014-05-02T05:26:30+00:00

    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

    Was this answer helpful?

    0 comments No comments