User Forms Question

[Fireguy5309]

Hi all,
I am trying to build a personnel manning book that will track our manning for the next few years. I have built a user form but have no idea on how to program it to work properly. It will take the information typed into the boxes, decide via 2 check boxes whether the person is military or civilian and assign to a specific sheet via the radio button that is clicked. I have also placed a check box that tells whether the person is inbound or not. If anyone would like to take a look at it and give me some hints on how to do this I would greatly appreciate it.

Fireguy

 

[ccomeaux]

I will take a try at this. I made a userform and placed a text box a command button a check box and two radio buttons. in the first radio button place this code.

If OptionButton1.Value = True Then
Worksheets("Sheet1").Activate

In the second radio button place this code.

If OptionButton1.Value = True Then
Worksheets("Sheet2").Activate

In the command button place this code.

Cells(1, 1) = TextBox1.Value

And in the check box place this code.

If CheckBox1.Value = True Then
CheckBox1.Caption = "Military"
Cells(1, 4) = "Military"
Else
CheckBox1.Caption = "Civilian"
Cells(1, 4) = "Civilian"
End If

In the userform: Fill in the text box with a name and click on the checkbox for the right value and pick the sheet to use on the radio buttons. Then click the command button. This should get you on the right track.