Populating Custom Ribbon DropDown from a dynamic NamedRange

[ImranBhatti]

Hi,


I have the attached XML code for a simple custom ribbon



What I want is to load a dynamic named range instead of Red font items in the Xml code(hard coded)

myDynamicRng=Range("A5:A" & Range("A" & Rows.Count).End(xlUp).Row)

I also want my Dataset ("A5:G & LastRow) to be filtered on the basis of selection in this dropdown

Further dropdown list should be updated on the fly if I add/Delete items in the data set


Help would be greatly appreciated

Best Regards
Imran Bhatti

[ImranBhatti]

Any one please?

[romperstomper]

You've already got a similar thing set up with your combobox, so what problem are you actually facing with replicating that for your dropdown?

[ImranBhatti]

Thanks rory .Acually I got the combobox code from the internet for worksheet navigation.
But for the other one I want to get the list in the "Batch Folders" sheet Range("A5:A" & LastRow)
and I am unable to configure that. while having the workbook opened this list may increase in length or decrease.
I am weak in Ribbon UI Manipulation. The existing Ribbon stuff in the workbook was my first attempt to reshap the UI of a workbook.

[romperstomper]

I am weak in Ribbon UI Manipulation.

And the best way to change that is to look at the combobox code and tweak it for your dropdown. It's basically the same principle except you read a cell value using the index instead of a worksheet name.