+ Reply to Thread
Results 1 to 6 of 6

ActiveX-Control Elements behave weirdly after hiding and unhiding

  1. #1
    Registered User
    Join Date
    11-01-2019
    Location
    Frankfurt, Germany
    MS-Off Ver
    2016
    Posts
    3

    ActiveX-Control Elements behave weirdly after hiding and unhiding

    Hi Folks,
    I've been searching for a solution to my problem everywhere since monday and i couldn't find anything. I'm actually coding an Excel macro with some checkboxes, commandboxes and textboxes in it and the aim is that by clicking on some boxes, some lines should be hidden and the Activex elements in those lines as well. However after a line has been hidden and unhidden the activex elements in it don't react to a click anymore and when i close and open the file the same activex element aren't in the line the were supposed to be anymore. They just migrate to somewhere else in the sheet. This is very frustrating and this macro it a part of my thesis. Please help me solve this.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: ActiveX-Control Elements behave weirdly after hiding and unhiding

    Several views and solutions in this thread.
    torachan.


  3. #3
    Registered User
    Join Date
    11-01-2019
    Location
    Frankfurt, Germany
    MS-Off Ver
    2016
    Posts
    3

    Re: ActiveX-Control Elements behave weirdly after hiding and unhiding

    Thanks, i've a meeting in a minute. I'll give you a feedback once i've tried it.

  4. #4
    Registered User
    Join Date
    11-01-2019
    Location
    Frankfurt, Germany
    MS-Off Ver
    2016
    Posts
    3

    Re: ActiveX-Control Elements behave weirdly after hiding and unhiding

    I've tried the options in the link but it is still not working. Everytime i hide and unhide an activeX element it would behave crazy.

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: ActiveX-Control Elements behave weirdly after hiding and unhiding

    Just use forms controls rather than ActiveX, ActiveX controls on worksheets are asking for trouble

  6. #6
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: ActiveX-Control Elements behave weirdly after hiding and unhiding

    I agree with Kyle. I prefer to use 'Forms' Controls, Shapes and/or UserForms.

    Lewis

+ 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. [SOLVED] Hiding column causes VBA code to behave not as expected
    By kampatel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2016, 05:50 PM
  2. Replies: 8
    Last Post: 01-23-2015, 02:32 PM
  3. Hiding unhiding columns
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2010, 11:24 AM
  4. Hiding or unhiding a picture
    By krabople in forum Excel General
    Replies: 3
    Last Post: 11-08-2006, 01:03 PM
  5. [SOLVED] Hiding/Unhiding Columns
    By xkarenxxxx in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-05-2006, 09:25 AM
  6. [SOLVED] Hiding and Unhiding Worksheets
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2006, 07:15 AM
  7. Hiding/Unhiding
    By Bobby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-25-2005, 05:43 PM

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