Run different Macros based on what selections have been made in checkbox

Hi,
I am creating a BoM table. There are different option content for the product. I have a set of checkbox (Form) that I have on the first tab. For instance, the product can have
1. 7.6Kwh
2. 15 Kwh
3. 23 Kwh

the second set of options are:
1. HVAC
2. Heater Only

the third set of options are:
1. Red
2. White
3. Blue

I have separate tabs for each of these option sets and I have created a blank template sheet. I want the macro to populate the blank template based on the selection made on the first page. For instance, if I select 7.6, Heater and White, I want the macro to copy the info from those 3 tabs and paste them in the blank template.

Can this be done? Appreciate the help...

Assuming the data you populate the 3rd sheet with comes from the other tabs for each option an example spreadsheet would facilitate a detailed response.
It certainlyy sounds simple enough.

Hi Brynbaker,
Thanx for the response. Yes, the data are in different tabs. I am attaching the file for your review. I plan on showing only the "Welcome" and the "BoM" tabs to the users. They will select the options they want from the Welcome screen and when they click the command button I want it to run the macros based on the selections made.

Thank you again.

Apologies for the delay; this PC has Office 2010 but rejects downloads from the forum; my home PC has 2003. I have another option that I will try as soon as possible.

Originally Posted by brynbaker

Apologies for the delay; this PC has Office 2010 but rejects downloads from the forum; my home PC has 2003. I have another option that I will try as soon as possible.

Hi Brynbaker,
Appreciate your help. Looking forward to your comments.

I had not forgotten, but I have been thwarted in my attempt: A major domestic upheaval has mislaid (I hope that's the right word) my laptop. I hav unable
Incidentally it may be time to update your details; the stuff at left of your posts says 2003 but you've uplaoded a .xslx file? I have managed to load part in 2003 and it may be enough though the conversion listed 4 problems. Before I get timed out I will pause and read what i loaded...

Hmm. Well I see that you have used the macro recorder to develop some of the code - right on! More people should try that. But it's wise to read and tidy what you get, eliminating the unnecessary (for example spurious "Ramg3("A6".Select") when you click a cell you don't really need to while recording.
Anyway it is a bit hard to follow. And I don't use userforms (mo-one has shown me any advantage in simple design). But I do know that options usually require an option button so that (for instance) one cannot order a car that both has and ddoes not have a heater!

Apart from these slim pieces of advice, I think the issue about loading the unconverted file in the correct Excel version prevents me from helping you further at present. I hope another member is better placed to help. I will monitor the thread in case I can do more.

Hi,
Thank you for your comments. Yes, i mostly used the recorder and a bit of help from other members to create some of the VB. I can save the file in a earlier format if that helps. Appreciate any help.

Regards

And I apologize, my Excel is Excel 2010

I also have 2003, so I cannot view your file.
But in general your code will be a lot more straightforward if you use listboxes for those choices.
I would also ask why you have separate tabs for those options.

John thanks for your input. I diid look up Atwood Lake: very nice. I'm jealous.