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:
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:
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!
Bookmarks