+ Reply to Thread
Results 1 to 3 of 3

Creating a worksheet ActiveX button via code seems different than one from Control Toolbox

  1. #1
    Valued Forum Contributor
    Join Date
    11-15-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2003
    Posts
    536

    Creating a worksheet ActiveX button via code seems different than one from Control Toolbox

    Note this may be version specific; I'm on 2003. In 2003 View/Toolbar/Control Toolbox and drag command button to sheet to create a command button. Then in design mode, right click, and you see "properties" where you can, e.g. set an accelerator.

    But if you use the code below (which is what macro recorder shows for what I just described, by the way) (and matchs Help example for Add method for OLEObjects), right clicking has no "properties", and the button is not as versatile - for example, I have been unable to set an accelerator. Can someone explain the difference? (BTW, browsing the watch window shows both are OLE type 2, but there are other property differences apparent from comparing in the watch window).
    Please Login or Register  to view this content.
    Chip, if you can read this, you're STILL making the world a better place with your immeasurably valuable gifts. Every week, you continue to help me (and untold numbers of others) tremendously. Practically no alternative outlets can match your effectiveness, even over the vast number of topics you demystify and empower usage of. You were, and still are, amazing.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,914

    Re: Creating a worksheet ActiveX button via code seems different than one from Control Too

    There is a little reading to read about it, e.g. Ms context help in vba.
    'Using ActiveX Controls on a Document' / 'Using ActiveX Controls on Sheets'.

  3. #3
    Valued Forum Contributor
    Join Date
    11-15-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2003
    Posts
    536

    Re: Creating a worksheet ActiveX button via code seems different than one from Control Too

    This was responded to in another thread, reproduced here.

    Thank you for the useful and on point response.
    Quote Originally Posted by xlnitwit View Post
    No, they aren't. It's the same control
    Okay, you're right. I'd still like to know if anyone knows how to add "Properties" to right click since it does not appear on the generated button (the only meaningful difference I now see).

    If you wanted to add an accelerator using the code in your other thread you should only need to add
    Please Login or Register  to view this content.
    Sorry, you're right, my mistake - setting the accelerator for either of those that way is no problem.

+ 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. ActiveX Control Spin Button Copy Button and Change Cell reference?
    By chrstphrbllngs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2016, 04:01 PM
  2. [SOLVED] Copy ActiveX Button and Code to another Worksheet
    By Jan Lichtenbelt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2014, 07:20 AM
  3. [SOLVED] ActiveX Control Button in Protected Worksheet - Excel 2010
    By cblp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2014, 11:48 PM
  4. Command Button from Control Toolbox
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2006, 01:10 PM
  5. [SOLVED] How to format control toolbox option button?
    By Rafat in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 07:35 PM
  6. Control Toolbox button
    By PBS in forum Excel General
    Replies: 1
    Last Post: 03-21-2006, 07:45 PM
  7. How to put a button made through Control Toolbox
    By jose luis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2005, 03:50 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05645 seconds
  • Memory Usage 8,955KB
  • Queries Executed 15 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (2)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (3)postbit_legacy
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (48):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1