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!
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!