Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
REad Only Spreadsheet Joel Excel Discussion (Misc queries) 2 September 4th 08 12:59 PM
Copy parts of a data range into a new spreadsheet forest8 Excel Worksheet Functions 4 April 21st 08 08:26 PM
How do I hide spreadsheet range from data entry? Deborah_NY Excel Worksheet Functions 1 May 22nd 06 02:43 PM
External Data Queries - Data Range Properties v Spreadsheet Format HLS Excel Discussion (Misc queries) 0 April 5th 06 11:09 AM
Read Only spreadsheet Pearl Excel Discussion (Misc queries) 1 December 21st 05 05:12 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"