Digita
01-05-2009, 04:02 PM
Happy New Year,
Hope you all had a good break. I have a userform with a listbox linking to a worksheet range with 4 columns of data. The figures in 1 of the columns in % format. However, when these numbers are populated into the listbox their format is lost. How do I retain the number format of that particular column when shown in the listbox?
Thanks in advance.
Regards
kp
PS: I attached a sample file for your reference.
Hope you all had a good break. I have a userform with a listbox linking to a worksheet range with 4 columns of data. The figures in 1 of the columns in % format. However, when these numbers are populated into the listbox their format is lost. How do I retain the number format of that particular column when shown in the listbox?
Thanks in advance.
Regards
kp
PS: I attached a sample file for your reference.