+ Reply to Thread
Results 1 to 2 of 2

Active X Checkboxes not working on Mac

  1. #1
    Registered User
    Join Date
    07-30-2013
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Active X Checkboxes not working on Mac

    Hi All,
    I am new to this forum. I am trying to figure out how to fix a form I created. The form uses VB ActiveX check boxes. The user clicks the check box pertaining to what information they need to fill out and the rows of data not relevant for them disappear (ie I click the blue checkbox and all the other colors information disappears). It works fine on PCs but I am now hearing that Mac users can't click the check boxes. A Google search turned up that ActiveX won't work on Mac. What are my options? Can I use form control check boxes to hide rows? If so, how?

    Here is an example of the code I used originally when using ActiveX:

    Private Sub Skincare_Click()
    Range("A33:A37").EntireRow.Hidden = Skincare.Value
    Range("A61:A62").EntireRow.Hidden = Skincare.Value
    Range("A76:A86").EntireRow.Hidden = Skincare.Value
    Range("A96:A98").EntireRow.Hidden = Skincare.Value
    Range("A100:A102").EntireRow.Hidden = Skincare.Value
    Range("A112:A115").EntireRow.Hidden = Skincare.Value
    Range("A127:A129").EntireRow.Hidden = Skincare.Value
    End Sub

    Any help would be greatly appreciated!

    Thank you,
    Lacey

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Active X Checkboxes not working on Mac

    yes you can use form controls instead-just create a macro with your code and assign it to the control

    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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. Macro with checkboxes - not working
    By kaligad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2012, 06:23 AM
  2. Replies: 8
    Last Post: 08-22-2012, 03:22 PM
  3. inserting active x checkboxes with sequential names
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2012, 04:53 AM
  4. [SOLVED] Quick Start to working with checkboxes etc within a worksheet
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-15-2005, 08:05 AM
  5. Active X Checkboxes
    By Holanmeg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2005, 01:07 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