Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Control Toolbox Objects (XL97;SR2)

    Can someone provide a resouce for changing the properties of an object created with the Control Toolbox (View/Toolbars/Control Toolbox) through VBA. I know how to do it with a form(View/Toolbars/Forms) but this is a new challenge.

    Thanks,
    John

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Control Toolbox Objects (XL97;SR2)

    If you select the properties from the right-click menu for the object you can see the names of the properties

    In VB use the name of the object a period and the property name eg:
    activesheet.listbox1.height = 55
    Steve

  3. #3
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Control Toolbox Objects (XL97;SR2)

    John,

    A resource: XL VBA help - "Using ActiveX Controls on Sheets"

    Jim Cone
    San Jose, CA

Posting Permissions

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