+ Reply to Thread
Results 1 to 2 of 2

Use of other Tools in Macro

  1. #1
    Registered User
    Join Date
    08-18-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    35

    Use of other Tools in Macro

    Hello,

    I have been using Macro for quite a while but I am only limited to use the "Button" on the ActiveX tool for triggering my program. Can anyone have any of there example Macro to show how can we make use of the other ActiveX tool?

    Besides, what's the different between the Active X tool and non-Active X tool?

    Many thanks,

    Gordon

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Use of other Tools in Macro

    Hi Gordon,

    The standard controls only have the click event, while the ActiveX controls (and OLEObjects) have many.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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