Load Unique Value from xl sheet to combobox, Possible ???

[musa.biralo]

Hi,
Is it possible to load all the unique values from xl sheet to a
combobox??
Let's say we have 1, 2, 3, 3, 4 values in column A and i am dying hard
to load the unique values to a combobox in a userform.

So, my question, Is it possilbe?

if possible will you please direct me to the page where i can find the
info...or i will be very please if you guide me or share some info.

Huge Huge Thanks..

musa.biralo

 

[Jim Cone]

musa.biralo,

John Walkenbach has it all worked out here...
http://www.j-walk.com/ss/excel/tips/tip47.htm
"Filling a ListBox with Unique Items"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"musa.biralo" <[email protected]>
wrote in message
Hi,
Is it possible to load all the unique values from xl sheet to a
combobox??
Let's say we have 1, 2, 3, 3, 4 values in column A and i am dying hard
to load the unique values to a combobox in a userform.
So, my question, Is it possilbe?
if possible will you please direct me to the page where i can find the
info...or i will be very please if you guide me or share some info.
Huge Huge Thanks..
musa.biralo

 

[musa.biralo]

Hey Jim ....
Thanks a lot for providing the information.....it worked like a
charm...

thanx again.

musa.biralo