Apologies if this doesn't make sense...I don't entirely know what I'm talking about.
I have written some code which, when run, creates a worksheet. It's pretty much a table. When the sheet is created, I would like two checkboxes to also be created beside the table. These will be used to expose/hide certain parts of the table (but I'll worry about that part later). I've tried different code I've found but nothing works and I think it's because it is for adding a checkbox to a form and not directly into Excel. I've been trying to use something along these lines:
Set myLabel = frmMyForm.Controls.Add("Forms.Label.1", "lblPrompt")
But I don't exactly know what this does!
Also, would I embed this code along with my existing code or would it be a separate sub.
Thanks for any help!