Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cboBox to read data from a spreadsheet Range
With Worksheets("Sheet1")
varr = .Range("A1:A12").Value End with Combobox1.List = varr or do it directly With Worksheets("Sheet1") Combobox1.List = .Range("A1:A12").Value End with Regards, Tom Ogilvy "Igor" wrote in message ... Hi, I have a comboBox on the form, and i want it to read data array from the spreadsheet. Lets say i have months listed in cells A1:A12, how do i make combo box read from that. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REad Only Spreadsheet | Excel Discussion (Misc queries) | |||
Copy parts of a data range into a new spreadsheet | Excel Worksheet Functions | |||
How do I hide spreadsheet range from data entry? | Excel Worksheet Functions | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
Read Only spreadsheet | Excel Discussion (Misc queries) |