Code to make sure checkbox was selected

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,199
Office Version
  1. 2007
Platform
  1. Windows
Evening.

When my userform opens i have two checkboxes.
CheckBox1 & Checkbox2

The user MUST select one of them to see another checkbox etc before pressing the command button which transfers the values to my worksheet.

Currently there is nothing in place to see if Checkbox 1 or CheckBox 2 was selected.

Please can you advise.
Thanks.

Here is the command button code.

Rich (BB code):
Private Sub TransferButton_Click()

 With ThisWorkbook.Worksheets("RANGER")
    If CheckBox3.Value = True Then .Cells(lastrow + 5, 9).Value = "N 41601-501-41": CheckBox3.Value = False
    If CheckBox4.Value = True Then .Cells(lastrow + 5, 9).Value = "N 41803-501-42": CheckBox4.Value = False
    If CheckBox5.Value = True Then .Cells(lastrow + 5, 9).Value = "V 41803-501-43": CheckBox5.Value = False
 
 
    With .Range("I5")
        .Font.Size = 14
        .Font.Name = "Calibri"
        .Font.Bold = True
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlVAlignCenter
    End With

    With Sheets("RANGER")
        If .AutoFilterMode Then .AutoFilterMode = False
        x = .Cells(.Rows.Count, 5).End(xlUp).Row
        .Range("A4:I" & x).Sort Key1:=Range("B5"), Order1:=xlAscending, Header:=xlGuess
    End With

    Unload RangerPcbNumber
    End With
    MsgBox "DATABASE UPDATED SUCCESSFULLY", vbInformation, "SUCCESSFUL MESSAGE"
End Sub
Private Sub CheckBox1_Cha
 
that code looks pretty good. just put whatever text you had before.
1615373317365.png
 
Upvote 0

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
is it possible to link me the workbook so i get all that is going on. or at least can i see the whole userform. the code you just sent for TransferButton_Click is completely different from the previous code for the same thing
 
Upvote 0
OK
But first with regards frame2
Are we using optionbuttons or checkboxes as last screenshot has changed again.
 
Upvote 0
option buttons replace what was checkbox 4 and 5
 
Upvote 0
Download file from here please.


Open the form & select RANGER REMOTE
Enter anything in CUSTOMER VIN & YEAR
TYPE you need to selected ORIGINAL 2B
Then select either of the two option.

When you press TRANSFER another userform will open "this is the one we are working on"
It only opens because ORIGINAL 2B was selected.
At this point on the worksheet cell I5 is empty because this completed form will then enter a value in it.

If you select anything other than ORIGINAL 2B this userform will not open & N/A is then placed in cell I5

So by selecting 41601 then we see the pcb number & its then added to cell I5

So by selecting 41835 there are 2 types of pcb & by selecting one will then be entered in cell I5

This code tells me in the future the item supplied & the pcb used.

CLOSE just exits the form.

RESET clears value shown in textbox / combobox if done by mistake.

TRANSFER adds selected info into cell I5
 
Upvote 0
got it now. it is getting late here so i will call it a night soon. we can have a go at this tomorrow. i can take a better look with a bit more time...
 
Upvote 0
ok i see what you are doing now. this should be easy :)
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top