+ Reply to Thread
Results 1 to 4 of 4

ActiveX Spin button makes excel transparent

  1. #1
    Registered User
    Join Date
    01-12-2023
    Location
    Indiana, USA
    MS-Off Ver
    O365
    Posts
    2

    ActiveX Spin button makes excel transparent

    Good Evening Everyone,

    I'm having a very annoying issue. I have an activeX spin button and every time I click it my entire workbook goes transparent for a second. I'd be happy to post my VBA code if anyone thinks it's relevant, but it just scans the sheet for a cell, grabs the value, then increments another cell by a percentage of the cell value it found. The functionality works fine, it's just that whenever I click the activeX button it blanks our my screen. Has anyone encountered this issue? It does not happen with normal form controls.

  2. #2
    Forum Contributor
    Join Date
    10-02-2012
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    252

    Re: ActiveX Spin button makes excel transparent

    Honest answer. Don't use ActiveX controls, they are unsupported and potentially dangerous (depreciated since 2015). Use the Spin button included in the WinForm controls.

  3. #3
    Registered User
    Join Date
    01-12-2023
    Location
    Indiana, USA
    MS-Off Ver
    O365
    Posts
    2

    Re: ActiveX Spin button makes excel transparent

    I've read that everywhere. Unfortunately that means there's now way to interact with the buttons through VBA correct?

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: ActiveX Spin button makes excel transparent

    Let's see the code or supply a sample workbook.

+ 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. Replies: 9
    Last Post: 05-15-2019, 09:30 AM
  2. Transparent background of ActiveX control
    By dlh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-15-2017, 10:00 PM
  3. 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
  4. [SOLVED] Help with Spin Button. Set Spin button starting value based on a text box value
    By etuckram in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-18-2014, 10:05 AM
  5. ActiveX Spin Button LinkedCell Question
    By speed007 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-21-2014, 08:08 PM
  6. Spin Button:spin cells A7
    By ice in forum Excel General
    Replies: 1
    Last Post: 03-16-2007, 02:23 PM
  7. Replies: 5
    Last Post: 04-23-2006, 08:00 AM

Tags for this Thread

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