Hi,
I currently creating a VBA in excel and one of the forms I am using has 2 option button (for Yes and No option) to determine which form to load once i click an image (named Next) however I am getting the error "Compile Error: Method or data Member not found". Below is the code i used:
Private Sub Image5_Click() ---> image named "NEXT" to move to the next form
Dim Selection As Integer, result As String
Selection = Sheet1.Range("E2:E3").Value
If Me.OptionButton1 = True Then BT9_10.Activate ----> "Yes" option button
If Me.OptionButton2 = True Then BT4_Offers.Activate ----> "No" option button
End Sub
Bookmarks