Set combobox number format

**JonathanEngr** · 10-21-2016, 10:30 AM

I'm pulling my hair out trying to figure out how to do one simple (??) thing. I have a combobox that is initialized when a form is opened with the following code:

Please Login or Register  to view this content.

This is used to select the time (in minutes) for scheduling. (I have another for choosing hour). The cells shown, B1:B60, are formatted to show two numbers so that minute 1 shows up as 01, 2 as 02 and so-on. But when these numbers are imported into the combobox list they display as 1, 2, 3, etc., instead of 01, 02, 03 and such. I have tried numerous different methods of number formatting to no avail. Some are shown below:

Please Login or Register  to view this content.

I assume it's something with the syntax? I haven't tried a piece of code I saw that assigns a format when values are brought in individually (I would have to change my import code). Can someone shed any light on what I'm doing wrong? Thanks!

**Norie** · 10-21-2016, 10:39 AM

So you want to populate the listbox with 01, 02, 03, 04... 59, 60?

Or is it the specific values in the range B1:B60 formatted to 2 digits you want?

This will do the former,

Please Login or Register  to view this content.

this will do the latter.

Please Login or Register  to view this content.

**grimes0332** · 10-21-2016, 10:40 AM

Ignore....

@mikerickson - my answer was a 'shot in the dark' but as a working solution was posted at about the same time so I removed it.

**mikerickson** · 10-21-2016, 10:46 AM

Grimes0332, the .Text property of a range does not return an array.

One would have to loop

Please Login or Register  to view this content.

**JonathanEngr** · 10-21-2016, 11:03 AM

So you're basically importing it as a text entity, correct? I thought about doing that, but I use the numbers in a few equations. Will I need to convert them back to numbers (integers) before mathematical manipulation?

I know this is a shift in the original question, but is there a simple way to invoke a *time only* clock, etc., from within VBA to select the time? This was my initial thought/plan, but all I could find was the time/date utility, and many people said it acted inconsistently based on the version of excel one used.

**Norie** · 10-21-2016, 11:16 AM

Did neither of my suggestions work?

**JonathanEngr** · 10-21-2016, 05:59 PM

Norie--First of all, thank you for responding! I haven't had a chance to try them yet, but I did want to ask about the variable type since the weekend was approaching (trying to be proactive in case I got some type of error). I remember one time long ago having an issue with a number, and it's because it was being seen as text instead. It may not apply here, but I thought I would ask :-)

I'll be sure and post back my results after editing my code. Thanks again!

**mikerickson** · 10-21-2016, 07:20 PM

The items in a ComboBox's list (or a ListBox's) are strings. Unlike cells, they don't have a format.

The code has to be written to apply formats before putting the strints into those .Lists

Set combobox number format

LinkBack

Thread Tools

Rate This Thread

Display

Set combobox number format

Re: Set combobox number format

Re: Set combobox number format

Re: Set combobox number format

Re: Set combobox number format

Re: Set combobox number format

Re: Set combobox number format

Re: Set combobox number format

Thread Information

Users Browsing this Thread

Similar Threads

Need formula or code to convert number(s) from custom format to number format

Code for combobox to number format

date Format in Combobox - format changes when data is transferred to database??

[SOLVED] Decimal Number Format in ComboBox

[SOLVED] Number format:how I can change the default number format to show blank spaces ?

[SOLVED] Number format for Combobox

Number format based on number format of another cell in another workbook

Bookmarks

Bookmarks

Posting Permissions