Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 159
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula explanation Hoops Excel Discussion (Misc queries) 3 January 20th 10 03:59 PM
Need an explanation JLGWhiz Excel Programming 2 June 15th 07 08:13 PM
Explanation of when & how to use ( ) { } : ; , ! etc? Paul (Sydney Australia) New Users to Excel 4 May 2nd 07 01:54 AM
Formula Explanation Please Ken Excel Discussion (Misc queries) 0 May 1st 07 02:23 PM
Comma explanation George Excel Worksheet Functions 3 December 13th 04 09:30 PM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"