Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill in Combo Box with range values????
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill the values in combo box of excel sheet | Excel Worksheet Functions | |||
fill in data range knowing start and end values | Excel Worksheet Functions | |||
registering the cell values of excel combo box associated values | Excel Programming | |||
Combo Box Fill Range | Excel Programming | |||
How to get a range of values into a combo placed on USERFORM? | Excel Programming |