tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,832
- Office Version
- 365
- 2019
- Platform
- Windows
If I declare a variable at the top of a standard module, such as:
I can use it within that module.
However, if I declared abc within a worksheet, userform or class module, I can still use it but this does not work:
Instead I must drop the Me.
Why is it that it "does recognise" abc, yet does not allow Me (unless abc was declared Public)?
Thanks
Code:
Dim abc As Long
I can use it within that module.
However, if I declared abc within a worksheet, userform or class module, I can still use it but this does not work:
Code:
Me.abc = 10
Instead I must drop the Me.
Why is it that it "does recognise" abc, yet does not allow Me (unless abc was declared Public)?
Thanks