Variable Input Range for Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box which will give a different list depending on other
selections made by the user.

I have been able to generate the relevant list in a certain range of cells
(let's say column A) but the length of the list varies dramatically depending
on which list is active. It can be anywhere between 2 options and approx 150
options.

If the list is short I want to only show the two options in the list without
a long blank list below it. I have generated a cell which calculates the
number of options in the list but I can't work out how to integrate this into
the input range control on the combo box.

Can anyone help?

Thanks

Phil
 
Thanks Duke! There's some really clever people around here, which is a
godsend to us not so clever ones!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a combo box that is tied to another combo box? 2
How to combine Combo Box function with Vlookup function 2
Combo Box Imbedded in Cell? 1
Access Cascading combo/query in table/subform 0
Input Range for a List Box 1
Access MS Access Listbox not saving to bound field 0
Multiple lists in a cell 1
Dependent drop down dynamic range formula, off sheet. 7

Back
Top