User Form Coding Inquiry

Hey all,
I am new to excel with little VB experience. I plan on beginning online tutorials soon. I have a vision right now and need advice on how to proceed. To make simple, I work with engineers who need specific forms for certain tests. I have all the test forms in difference excel sheets in one file. I'd like to make a userform that takes in two forms of data.

The first is a checkbox - Suppose "test A" is checked, it will then take that excel sheet and bring it over to a new excel sheet. When multiple tests are needed, they will need a new sheet that is unique with specific sheets.

next is a set of data that is filled out in text boxes that then fill in certain other areas. So if userform asks for client name, they put in the name and it populates that to the header....

This is simple commands but have no clue on how to go about it YET. So please help me out. Thanks all! I'll be a contributor once I learn more!

Start here: (below in next post)

Start with the attached file w macro.
Pick Tests to take.xlsm

Ranman256 that was fast!
I'm beginning to edit that to accommodate all my testing. Thank you! Was this a template somewhere or did you write it? Can you recommend tutorials with VB and these sorts of operations?

I wrote it.

To learn VBA, the best way is to record a macro and click your steps. (not for your program...yours was a bit more difficult)
But by recording then viewing the code, you can see how the excel objects work.
Also, a beginners guide to BASIC will help on constructing loops, and using variables.

Good luck.

Ok Ranman.
I tried to make more checkboxes to allow for more tests. I couldnt determine how to do so.

Is there a way to create the userform that looks prettier to do the same thing. I can't find any code via google that meets my needs to allow for checkboxes to be checked and then the command button to unload it. I looked at the code you created and (as a newbie) was unable to decipher it. It look as if there was only code for checkbox A and C but none for B, yet it still worked.

I imagine that each userform checkbox would have only a few lines of code that use the logic of "If true, select "sheetA", copy "SheetA", Send to workbook2" Yes?

TL;DR, unable to modify your code to fit my needs :/

Did you assign each checkbox to their cells?
When you right-click the checkbox, it shows the CELL LINK property.
The check box value is put here (in Z column) Y col has the test name.
The app scans these columns.

Actually what I just found that works is this :

Dim WB As Workbook

If CheckBox1.Value = True Then
sheets("PQC 1001").Copy
Set NewBook = Workbooks.Add
With NewBook
End With
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Else: CheckBox1.Value = False
End If

If CheckBox2.Value = True Then
sheets("PQC 1002").Copy
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Else: CheckBox2.Value = False
End If

End Sub

Sub CommandButton2_Click()
Unload Me
End

I think we may have been using two different avenues...I dont know enough to know.

Now i'm just trying to add text boxes to add data to the header of a workbook....

That requires code. Mine did not. But whatever works for ya!