Identifier under cursor is not recognized error

Confusion.jpg

I am new to VB and have little experience coding.

I have attached the image of what error is highlighting and how it is affecting me.


In the sub, I have visual basic menus popping up asking yes or no questions. If answered yes, Alt1 = "1", if answered no, Alt1 = "0".
Then I'm referencing to those variables to set values to the variables shown. I just don't know what I'm doing wrong.

Thank you for any help offered

Is this because 'Dim' cannot reference a value in a cell? Is there a way to have a variable in the code reference a numeric value of a specific cell?
ie: I was the variable Alt1Lab to equal the value of cell D17 of sheet 'Bid Summary'.
Thank you for the help

That was reasonably helpful! Thank you - the error has gone away, however, now I have a different issue. I did the following:
- switched the variables to Variant instead of Long
- Referenced them as suggested using.Value

Now I have a section of code that is trying to use those values in a summation and on the sheet, there is a #Name? because it is adding a value and 'Alt1Lab'.

Please Login or Register  to view this content.

After the macro runs, the cell states ='Bid Summary'!D17+Alt1Lab+Alt2Lab+Alt3Lab+Alt4Lab+Alt5Lab and the #NAME? code appears.

Any other suggestions?

I have changed the code to you recommendation however the #NAME? Error still remains although the resultant in the cell is different.
It now shows the following:
='Bid Summary'!D1714163.492

I cannot reference the cell directly because it doesn't always apply (unless the user clicks on the 'yes' button when prompted with the yes or no question. I thought I might be able to set up several different cases which would reference the specific cells and choose the appropriate cells when necessary but there are over 100 possible combinations of yes/no and that would take an enormous amount of code.
Any other suggestions?

Here is what I currently have:

Please Login or Register  to view this content.

What a guess. You got it perfect. Thank you very much. I really appreciate the help from both of you. Reputation Added.