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

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

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

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"
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

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

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

thanx again.

musa.biralo

On Nov 10, 8:15 pm, "Jim Cone" wrote:
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, USAhttp://www.realezsites.com/bus/primitivesoftware

"musa.biralo"
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