ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Explanation please (https://www.excelbanter.com/excel-programming/400335-explanation-please.html)

Mekinnik

Explanation please
 
For the life of me I cannot remember how the use of 'Me' works. If I use me
like in the following line of code: 'Me.Cbxuse.Value' Does it refer to the
open worksheet or is it what it is attached to like a user form?

Bob Phillips

Explanation please
 
It refers to the containing object, such as the Userform that the control
in question is part of, or the worksheet that an object is within

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mekinnik" wrote in message
...
For the life of me I cannot remember how the use of 'Me' works. If I use
me
like in the following line of code: 'Me.Cbxuse.Value' Does it refer to the
open worksheet or is it what it is attached to like a user form?




Bob Phillips

Explanation please
 

"JLGWhiz" wrote in message
...

In a control click event it applies to the control.


Me has always applied to the container even when in a control click event in
all the code I have written.




All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com