One Combobox for multiple excel sheets

[nickdel]

Ok, I have a feeling I know the answer to this in that I need to create some sort of class object but I need clarification...

I want to have a combobox on multiple excel sheets, the combobox is simply a quick menu option and it will have consistent values no matter what sheet it is on. My question is... How can I create just one instance of this and then use it across on all my sheets?

Hope that makes sense!

Thanks

Nick

 

[nickdel]

Never mind, I did answer my own question... one of those days!