PC Review


Reply
Thread Tools Rate Thread

Conditional Combo Box Fill

 
 
=?Utf-8?B?U3RldmU=?=
Guest
Posts: n/a
 
      28th Jun 2007
I would like to fill a combo box using a condition. That is, every cell in a
column that meets the condition, would be loaded into the box. For an
example, every cell that is a certain color. Perhaps I could use an offset
(i.e. every cell that is adjacent to a cell that has a certain character).
What I am trying to accomplish is a means to jump to an indexed area. I have
it working now, by creating the list (combo box fill range) on a separate,
hidden, worksheet. The limitation is not being able to add to the list on
the fly, and sometimes I get an error message (while scrolling the box) that
there is not enough resources to display the text. Apparently this is a
result of my box being linked to a list that is on a different worksheet.

Thanks,
Steve
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to fill a combo box with choice from another combo box Brian Microsoft Excel Programming 7 20th Apr 2010 09:14 AM
combo box selection to auto fill a second combo box (or field) MSA Microsoft Access Forms 1 28th Feb 2008 09:05 PM
conditional for fill color? jdifrancesco1@gmail.com Microsoft Excel Programming 2 19th Mar 2007 05:21 PM
Auto Fill In Combo Box From Combo Box Maurita Microsoft Access VBA Modules 4 13th Dec 2006 04:56 AM
Conditional fill =?Utf-8?B?UGEgTWFoZXI=?= Microsoft Excel Misc 1 19th Sep 2006 04:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:31 AM.