+ Reply to Thread
Results 1 to 3 of 3

Why enableevents is classed as a property and not a method

  1. #1
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Leeds
    MS-Off Ver
    Microsoft Office 365
    Posts
    271

    Why enableevents is classed as a property and not a method

    Good morning,

    I am new to VBA. Application.EnableEvents=True or False
    Why do we consider "EnableEvents" a property and not an action(method)? I googled it but didn't understand the concept. I would really appreciate a simple example to help me understand the concept.
    Thank you in advance.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Why enableevents is classed as a property and not a method

    Application.EnableEvents isn't an action, its the answer to a question (it is a boolean value).

    It doesn't do anything, it answers the question "are events enabled". Its a property not a method.

    Contrast that with Range.Sort method, which doesn't answer any question (it won't tell you if the range is sorted), but will perform an action, sort according to the arguments passed.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Leeds
    MS-Off Ver
    Microsoft Office 365
    Posts
    271

    Re: Why enableevents is classed as a property and not a method

    Thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. New to excel vba. Need help with my project.property inspection method
    By laddcarl in forum Hello..Introduce yourself
    Replies: 7
    Last Post: 06-02-2018, 02:40 PM
  2. Object doesn't support this property or method
    By amartino44 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2013, 10:05 AM
  3. object doesn't support this property or method
    By teowchy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2013, 03:16 AM
  4. how to define this method or property in form
    By jay11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2010, 06:58 PM
  5. Object does not support this property or method
    By Japi_s in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2007, 02:41 AM
  6. property method listing after dot
    By matrixknow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2007, 05:20 AM
  7. [SOLVED] Workbook Property or Method
    By Gary''s Student in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2006, 11:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1