User Forms Question

Fireguy5309

Board Regular
Joined
Dec 12, 2005
Messages
81
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

ccomeaux

New Member
Joined
Dec 20, 2005
Messages
15
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,111
Messages
5,570,257
Members
412,313
Latest member
pauloalex
Top