Excel userform listbox data entered as number.

[King Roberto]

Hi everyone,

I was wondering if you can enter data into a listbox as a number?

As far as i can find out it seems that listboxes only allow data to be entered as text.

I have been looking for a few days now but don't seem to find any specifications on listboxes...

Any help would be greatly appreciated :D

 

[Siddharth Rout]

Listboxes store the data as text. Whether you add number or say date using .Additem, it will be stored as text. What exactly are you trying to achieve?