I'm trying to create a drop-down list in a combo box from the Control Box
toolbar, as I need to be able to play around with the font size, but I can't
get it to work. Could someone please tell me where I'm going wrong?

My sheet is called Purchaseorder. I've got a list of companies in cells A1
to A10 that I want to appear in a drop-down list.

I've got an empty combo box open and now need to put in the data from cells
A1 to A10. Having read a few replies to other people's questions about this
subject, I'm still struggling to do it!

I right click on the combo box and go to Properties, where I see a long list
of options I can change. I go to ListFillRange and type in
Purchaseorder!A1:A10. There isn't an OK button or anything, so I just close
the Properties window. But nothing happens! I just can't get the data to go
into the box.

Can anyone help? It's driving me crazy! Thanks very much,

KarenPF

What you are doing is correct. Once you have entered the information in the
ListFillRange field, Excel will leave you in Design View. Every time you
click the combo-box you'll select it again. Switch off Design View (the
toggle button on the Control Toolbar that looks like a set square, pencil and
ruler).

Then click the arrow on your combobox and your list should be there.
--
Kevin Ciccone


"KarenPF" wrote:

I'm trying to create a drop-down list in a combo box from the Control Box
toolbar, as I need to be able to play around with the font size, but I can't
get it to work. Could someone please tell me where I'm going wrong?

My sheet is called Purchaseorder. I've got a list of companies in cells A1
to A10 that I want to appear in a drop-down list.

I've got an empty combo box open and now need to put in the data from cells
A1 to A10. Having read a few replies to other people's questions about this
subject, I'm still struggling to do it!

I right click on the combo box and go to Properties, where I see a long list
of options I can change. I go to ListFillRange and type in
Purchaseorder!A1:A10. There isn't an OK button or anything, so I just close
the Properties window. But nothing happens! I just can't get the data to go
into the box.

Can anyone help? It's driving me crazy! Thanks very much,

KarenPF

Karen, the list will only appear when you show/run the dialog. A quick way
to do so is to select the dialog in the VB editor and press F5.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"KarenPF" wrote in message
...
I'm trying to create a drop-down list in a combo box from the Control Box
toolbar, as I need to be able to play around with the font size, but I
can't
get it to work. Could someone please tell me where I'm going wrong?

My sheet is called Purchaseorder. I've got a list of companies in cells
A1
to A10 that I want to appear in a drop-down list.

I've got an empty combo box open and now need to put in the data from
cells
A1 to A10. Having read a few replies to other people's questions about
this
subject, I'm still struggling to do it!

I right click on the combo box and go to Properties, where I see a long
list
of options I can change. I go to ListFillRange and type in
Purchaseorder!A1:A10. There isn't an OK button or anything, so I just
close
the Properties window. But nothing happens! I just can't get the data to
go
into the box.

Can anyone help? It's driving me crazy! Thanks very much,

KarenPF

Thank you so much, Kevin. A perfect and simple description of what to do!

"Dom_Ciccone" wrote:

What you are doing is correct. Once you have entered the information in the
ListFillRange field, Excel will leave you in Design View. Every time you
click the combo-box you'll select it again. Switch off Design View (the
toggle button on the Control Toolbar that looks like a set square, pencil and
ruler).

Then click the arrow on your combobox and your list should be there.
--
Kevin Ciccone


"KarenPF" wrote:

I'm trying to create a drop-down list in a combo box from the Control Box
toolbar, as I need to be able to play around with the font size, but I can't
get it to work. Could someone please tell me where I'm going wrong?

My sheet is called Purchaseorder. I've got a list of companies in cells A1
to A10 that I want to appear in a drop-down list.

I've got an empty combo box open and now need to put in the data from cells
A1 to A10. Having read a few replies to other people's questions about this
subject, I'm still struggling to do it!

I right click on the combo box and go to Properties, where I see a long list
of options I can change. I go to ListFillRange and type in
Purchaseorder!A1:A10. There isn't an OK button or anything, so I just close
the Properties window. But nothing happens! I just can't get the data to go
into the box.

Can anyone help? It's driving me crazy! Thanks very much,

KarenPF

Hi Dom,



Every time I click the ListFillRange and try to save, my values just
disappear!
I even tied to exit design mode..still same problem
I am running MS Excel 2003 SP3
What exactly am I dong wrong??


Thanks,


Gboye


"Dom_Ciccone" wrote:

What you are doing is correct. Once you have entered the information in the
ListFillRange field, Excel will leave you in Design View. Every time you
click the combo-box you'll select it again. Switch off Design View (the
toggle button on the Control Toolbar that looks like a set square, pencil and
ruler).

Then click the arrow on your combobox and your list should be there.
--
Kevin Ciccone


"KarenPF" wrote:

I'm trying to create a drop-down list in a combo box from the Control Box
toolbar, as I need to be able to play around with the font size, but I can't
get it to work. Could someone please tell me where I'm going wrong?

My sheet is called Purchaseorder. I've got a list of companies in cells A1
to A10 that I want to appear in a drop-down list.

I've got an empty combo box open and now need to put in the data from cells
A1 to A10. Having read a few replies to other people's questions about this
subject, I'm still struggling to do it!

I right click on the combo box and go to Properties, where I see a long list
of options I can change. I go to ListFillRange and type in
Purchaseorder!A1:A10. There isn't an OK button or anything, so I just close
the Properties window. But nothing happens! I just can't get the data to go
into the box.

Can anyone help? It's driving me crazy! Thanks very much,

KarenPF

Hi Dom,
I did as KarenPF described in her question, but ListFillRange field on my
excel does not hold info I typed. It disappears right away; therefore, the
combo box shows nothing.
Thank you in advance and waiting for your response.
Anyone help would be appreciated.

Hahn



"Dom_Ciccone" wrote:

What you are doing is correct. Once you have entered the information in the
ListFillRange field, Excel will leave you in Design View. Every time you
click the combo-box you'll select it again. Switch off Design View (the
toggle button on the Control Toolbar that looks like a set square, pencil and
ruler).

Then click the arrow on your combobox and your list should be there.
--
Kevin Ciccone


"KarenPF" wrote:

I'm trying to create a drop-down list in a combo box from the Control Box
toolbar, as I need to be able to play around with the font size, but I can't
get it to work. Could someone please tell me where I'm going wrong?

My sheet is called Purchaseorder. I've got a list of companies in cells A1
to A10 that I want to appear in a drop-down list.

I've got an empty combo box open and now need to put in the data from cells
A1 to A10. Having read a few replies to other people's questions about this
subject, I'm still struggling to do it!

I right click on the combo box and go to Properties, where I see a long list
of options I can change. I go to ListFillRange and type in
Purchaseorder!A1:A10. There isn't an OK button or anything, so I just close
the Properties window. But nothing happens! I just can't get the data to go
into the box.

Can anyone help? It's driving me crazy! Thanks very much,

KarenPF

Hi someone,
I hope someone can help me to solve this problem.
I could create two combo boxes to link to a list of date, each combobox
linked to a different list of date, but when I clicked each combobox to
select a date, it did not show a date, it showed a number. Cell linked to it
also showed a number. If I converted that number, it would show a date, but
in combobox it would not show a date. How do I do to show a date in combobox?
Also, I want to code to if I select a date at this combobox, another
combobox will show another date that I want, that date is the same row, next
colum (in a different list). How to code? Or give another way to do this.
Thank you.
Nguyen