Fill in Combo Box with range values????
 

I want to fill in a combo box with 3 columns taken from a range on
sheet.

How would I do that?

I try fill range property but it does not work.

Thank you for any help.
Christiane


Below data from 3 columns:


CusNo: CustomerName Address1
27004000 ABSOLUTE COATINGS 38 PORTMAN ROAD
27010200 ABC DISCOUNT AUTO PARTS 2080 SPRINGDALE ROAD
27006000 ADCO CHEMICAL CO. 49 RUTHERFORD STREET
27055000 ADVANCED LIQUID RECYCLING 357 WEST MAIN STREET
27008000 ALLPRO CORP. 1215 MILLENIUM PARKWAY
27008000-35 ASHMONT SUPPLY 464 QUINCY AVE.
27022000 BENNYS 340 WATERMAN AVE.
27026000 BLASCO 100 WHIPPLE ST.
27021800-01 BRADLEES DISTRIBUTION CENTER 10 CLEARVIEW RD
27021800 BRADLEES STORES INC ONE BRADLEES CIRCL

--
Message posted from http://www.ExcelForum.com

Fill in Combo Box with range values????
 

Set the ListFillRange to A1:C20, and ColumnCount to 3.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Christiane " wrote in message
...
I want to fill in a combo box with 3 columns taken from a range on a
sheet.

How would I do that?

I try fill range property but it does not work.

Thank you for any help.
Christiane


Below data from 3 columns:


CusNo: CustomerName Address1
27004000 ABSOLUTE COATINGS 38 PORTMAN ROAD
27010200 ABC DISCOUNT AUTO PARTS 2080 SPRINGDALE ROAD
27006000 ADCO CHEMICAL CO. 49 RUTHERFORD STREET
27055000 ADVANCED LIQUID RECYCLING 357 WEST MAIN STREET
27008000 ALLPRO CORP. 1215 MILLENIUM PARKWAY
27008000-35 ASHMONT SUPPLY 464 QUINCY AVE.
27022000 BENNYS 340 WATERMAN AVE.
27026000 BLASCO 100 WHIPPLE ST.
27021800-01 BRADLEES DISTRIBUTION CENTER 10 CLEARVIEW RD
27021800 BRADLEES STORES INC ONE BRADLEES CIRCLE


---
Message posted from http://www.ExcelForum.com/

Fill in Combo Box with range values????
 

THank you, it works great

--
Message posted from http://www.ExcelForum.com