Returning a value of Checkbox

Joni_Depp

New Member
Joined
Mar 22, 2016
Messages
26
Hi I'm pretty much new in using check boxes and option buttons and i would like to seek your assistance with this problem.

I'm currently creating a form that reviews a certain audit that has been made based on the referenced row value.

Essentially this is the code that I have to return the value of a certain cell from one sheet that is referenced to another sheet (both are on the same workbook):

Private Sub CommandButton4_Click()
Application.ScreenUpdating = False
Dim i As Integer
Results = MsgBox("Do you want to View selected row?", vbYesNo, "")
If Results = vbYes And Range("F12") > 1 Then
i = Range("F12")
Worksheets("Sheet1").Range("C6") = Worksheets("Sheet2").Range("B" & i)
Worksheets("Sheet1").Range("C7") = Worksheets("Sheet2").Range("C" & i)
Worksheets("Sheet1").Range("C11") = Worksheets("Sheet2").Range("G" & i)
Worksheets("Sheet1").Range("C13") = Worksheets("Sheet2").Range("I" & i)
Worksheets("Sheet1").Range("F6") = Worksheets("Sheet2").Range("J" & i)
Worksheets("Sheet1").Range("F7") = Worksheets("Sheet2").Range("A" & i)

Now, I have 32 check boxes on sheet that are referenced to certain a specific cell, like check box 3 is linked to BZ84. The value "true or false" is transferred to sheet 2 and return the values on the same process similar to what is coded above.

Any help in this concern will be highly appreciated. Thank you!
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Forum statistics

Threads
1,223,228
Messages
6,170,874
Members
452,363
Latest member
merico17

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