Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 355
Default Combo Box Data Source

Can the data source for a combo box be an Array? If so, how is it specified?

Thank you
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,276
Default Combo Box Data Source

Hi Sandy,
Yes you can see Debra Web
http://www.contextures.com/xlDataVal01.html

"Sandy" wrote:

Can the data source for a combo box be an Array? If so, how is it specified?

Thank you

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 355
Default Combo Box Data Source

Thank you for this link - I found a lot of interesting stuff but I am not
finding the answer to my question. How to specify the array as the row source
for a combo box.

"Eduardo" wrote:

Hi Sandy,
Yes you can see Debra Web
http://www.contextures.com/xlDataVal01.html

"Sandy" wrote:

Can the data source for a combo box be an Array? If so, how is it specified?

Thank you

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,276
Default Combo Box Data Source

Hi Sandy,
That is made through a code according to how you named your tabs see same
web different page

http://www.contextures.com/xlDataVal11.html

Scroll down to the title Add the Code


"Sandy" wrote:

Thank you for this link - I found a lot of interesting stuff but I am not
finding the answer to my question. How to specify the array as the row source
for a combo box.

"Eduardo" wrote:

Hi Sandy,
Yes you can see Debra Web
http://www.contextures.com/xlDataVal01.html

"Sandy" wrote:

Can the data source for a combo box be an Array? If so, how is it specified?

Thank you

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,549
Default Combo Box Data Source

ComboBox1.List = Arr()
--
Jim Cone
Portland, Oregon USA


"Sandy"

wrote in message
Can the data source for a combo box be an Array? If so, how is it specified?
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
Combo Box row Source art Excel Programming 2 October 19th 08 09:05 PM
Combo Boxes as data source for a grapgh LuisE Excel Programming 2 July 2nd 08 01:32 PM
Combo box Row source Richard Excel Programming 2 June 21st 07 09:19 PM
Variable row data source for combo boxes? AndyRoo Excel Programming 4 June 2nd 06 09:13 PM
combo box from data validation with source list in separate sheet Jay Trull Excel Worksheet Functions 6 March 7th 06 01:59 AM


All times are GMT +1. The time now is 06:50 PM.

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

About Us

"It's about Microsoft Excel"