Items From Column Headers To Be Listed In ComboBox

[bakerman]

Try this one. Above each column i've placed a Combobox which is filled with a dynamic named range.
On selecting a name the rest is filled in.

[jeff]

Hi Bakerman
Thank you
I get a error when selecting the dropdown box
This line is in yellow but it looks the same as the other code lines *
Sheets("LISTS").Range("Group" & ComboBox5.ListIndex + 1).Copy Range("G11")
Thanks
jeff

[bakerman]

Try it like this.

[jeff]

Hi Bakerman

Excellent.That perfect

Can you make the combobox fit the size of the column.So if the column is 10 units wide the combobox fits or it the column is changed from 10 to 20 wide can the combobox then resize to 20...
Also how do i get the text to be larger

Thanks again and much appreciated

Jeff

[bakerman]

Automatically resize the CB's to Columnwidth NO, programmatically YES.
To enlarge the text goto designmode and select your CB, rightclick and select Properties, Select Font and there you can choose your Font size.

[jeff]

Thank you for all your help Bakerman