Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula explanation | Excel Discussion (Misc queries) | |||
Need an explanation | Excel Programming | |||
Explanation of when & how to use ( ) { } : ; , ! etc? | New Users to Excel | |||
Formula Explanation Please | Excel Discussion (Misc queries) | |||
Comma explanation | Excel Worksheet Functions |