I have a ComboBox in a UserForm that gets its values from a range in a work sheet via UserForm_Initialize.
On the worksheet, the values are fomatted as "0000000" to get a leading zero, but the formatting is lost between the worksheet and the ComboBox ie 0681212 becomes 681212 in the ComboBox.
Formatting the worksheet range as text works, but to save the user having to enter 500 numbers each time a new set is required, the 500 numbers are created based on the first number and then a simple +1 formula is used to create the remaining numbers.
If the range is formatted to text the +1 formula doesn't work.
How do I ensure the format is the same in the combobox as the range on the worksheet?
Thanks in advance.