Thanks wp, very helpful.
I did use the tab control from the from spreadsheet menu item, is that the one you mean?
At the moment, I'm just using an internal workbook because the aim will be to store the contents in a database, not a workbook.
I did look at the building a mini spreadsheet, which does indicate much the same as what you've helped with. And, apart from the reference to the underlying workbook, I've done pretty much as you suggested.
I'm still not clear how controls work on the tab, is this somehow dependent on making reference to the underlying source workbook?
Should the controls on a tab automatically change when I change tabs or do I need to manually work this. Or have I missed the point of the tabcontrol. I'm used to it being able to change the content when I change the tabs.
Sorry for being a bit slow on this, but once I grasp things away I go😁
Thanks
Dave