Error Message: Compile Error: Method or data Member not found

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:

Please Login or Register  to view this content.

Hello blei ,

First problem is you are using the keyword Selection. You cannot redefine VBA keywords in a Sub or Function procedure. Secondly, Sheet1.Range("E2:E3").Value will return a 2-D array of values an not a single integer.

I don't see the need to check the worksheet values since you are referencing the Buttons directly. What is the purpose of the cell references?

Hello blei ,

First problem is you are using the keyword Selection. You cannot redefine VBA keywords in a Sub or Function procedure. Secondly, Sheet1.Range("E2:E3").Value will return a 2-D array of values an not a single integer.

I don't see the need to check the worksheet values since you are referencing the Buttons directly. What is the purpose of the cell references?

Hello blei,

I assume you are using Forms buttons on the worksheet, correct?