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