Explanation please

[Guest]

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]

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)

 

[Guest]

One way to say it is, it applies to what the code is attached to.
In a control click event it applies to the control.
In a worksheet change event it applies to the work sheet.
etc .

 

[Bob Phillips]

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.