Cody;
Thanks for your quick respond.
I have tried the sample you gave me already. However, I wonder if I can get
the whole list in one time. I want to see the whole list of colors such as:
red (typed in cell B5)
yellow (typed in cell B6)
blue (typed in cell B7)
cyan (typed in cell B8)
as soon as I click the color description. The sample you provided me show
just one color at the time no the whole list.

Could you please help me with this matter.
I will really appreciate!!!!!!!
Maperalia






"Cody" wrote:

in the ListFillRange try Sheet1!B5:B8

LinkedCell to Sheet1!A1 (or wherever you like)


"maperalia" wrote:

I am in the process of learning VBA in Excel. I do not know how to adjuste
the "ListFillRange" and the "LinkedCell" in properties to get my sample done.

I have done a simple combo box sample. However, I cannot make the combo box
read a list of names I setup in the file.

When I click color I got just got red but I want to see the whole colors
list instead.

In another words, I want to know if I can get the whole list of the
description written in the list instead of just one name. For example when I
click color I want to see the whole list of colors such as:
red (typed in cell B5)
yellow (typed in cell B6)
blue (typed in cell B7)
cyan (typed in cell B8)

I will appreciate your helping me..

Thanks in advance.
Maperalia

P.D.
How can I send you my file for easy understanding?