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
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