Dependant ActiveX Combo Box list based on Data Validation List

Hi,

I've been looking high and low on a fix to my problem but can't find a solution so I apologize if there's already a thread on this. Here it goes...

I have an excel document, which I have developed into a great user form. I have taken advantage of Debra Dagleish's code to double-click and have the list auto-complete as the user starts typing - http://www.contextures.com/xlDataVal11.html. This is a feature my users cannot do without!

I now have to modify the ActiveX combo box to build the list based on what is selected in a small data validation list (i.e. no combo box). I expect to add some additional VBA code in order to have this work. I'm good with that!

- the data validation list is in cell B8
- there are various combo boxes but we only need to focus on one since they all work the same way - B26

So to re-iterate I'm looking to populate the combo box in cell B26 based on what's entered in B8 when a user double-clicks on the cell. I'm not sure if it makes a difference but all list references are on a different sheet.

I would like to post the document privately to whoever would like to help me because of the nature of the sensitive data.

Thanks you in advance for any help that can be provided!

Regards,
Suzi

Hi Glenn,

Appreciate the reply! I've reviewed your suggestion and it still doesn't seem to be working. I think with a lot of things I've read that I will most likely need to use VBA to have it work properly (but I may be over analyzing it! LOL). However, I did setup the data validation as per your suggestion from the Contextures tutorial. The formula I used in the data validation was =OFFSET(INDIRECT($B8),0,0,COUNTA(INDIRECT(B8&"Col")),1). It only returns the first item without double-clicking and when the double-click is used, nothing is returned.

I can send you the file privately, if this makes it easier to troubleshoot.

Regards,
Suzi

So Glenn and I have determined that the fix to my challenge will require VBA. Is there someone who can help me with a few lines of code? Again, I will send the excel document in a private message due to the sensitivity of the document.

Regards,
Suzi