+ Reply to Thread
Results 1 to 9 of 9

Activex problem

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    Mos Eisly
    MS-Off Ver
    Excel 2007
    Posts
    39

    Activex problem

    how many ActiveX controls can I insert on a Sheet??
    I'm crating a Time sheet, with 7 Toggle button for Each day... So far I reached September, but when I create the Oct Sheet, the Files crashes..
    is there a work around? I'm using by the way Office 2010.
    Last edited by Aranell; 05-20-2015 at 10:40 AM.

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

    Re: Activex problem

    ActiveX controls on sheets should be avoided. They are notoriously buggy and unreliable, try to use shapes of Forms controls instead.

    That said you should be able to put more than 7 on a sheet (I wouldn't though)

  3. #3
    Registered User
    Join Date
    11-16-2012
    Location
    Mos Eisly
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Activex problem

    no you understood me wrong I have 7 button for each day.. each Sheet is a Month so about 210 button per sheet nad like I said I have created Jan to Sep but when I create the Oct Sheet everything crashes and I can't open anymore the Excel Workbook.

    But Can you help me with these shapes? I need to have 7 Toggle buttons for each day and each button has a Tripplestate which mean 0, true and False

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

    Re: Activex problem

    Nooooo, don't do that It's a terrible idea. Don't use ActiveX controls on worksheets.

    Look for another way of doing what you're doing, how about ticks in cells that are toggled on or off with a double click? Using Cells is bay far the most stable method - Or how about using Validation drop downs?

    That said though, your design sounds wrong so we can't really make any suggestions without knowing what you are trying to do.

    How about uploading a sample workbook?

  5. #5
    Registered User
    Join Date
    11-16-2012
    Location
    Mos Eisly
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Activex problem

    The Problem is, I can't use checkbox.. I need to mark the day by "Full", "Half" or "none" .. thec checkbox give you only the possibility True or False

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

    Re: Activex problem

    I didn't anything about a checkbox...

  7. #7
    Registered User
    Join Date
    11-16-2012
    Location
    Mos Eisly
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Activex problem

    Well attached is my Workbook ( I've deleted all months except January)

    and I thought by ticks in cells you mean checkboxes...
    Attached Files Attached Files

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

    Re: Activex problem

    I'd go for something really simple:
    Please Login or Register  to view this content.
    And use conditional formatting icon sets to hide the numbers, see attached.

    This keeps things really simple and removes 90% of the code you have, the big advantage also is if someone is filling a lot of these in, they can still use tab as well as typing in numbers
    Attached Files Attached Files
    Last edited by Kyle123; 05-20-2015 at 09:33 AM.

  9. #9
    Registered User
    Join Date
    11-16-2012
    Location
    Mos Eisly
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: Activex problem

    You are my Hero :D.. thanks a lot I'll implement that immediately :D

    once I completed it i'll change the status to solved


    Thanks again.. it worked like a charm
    Last edited by Aranell; 05-20-2015 at 10:41 AM.

+ 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 Scrollbar Controls Problem
    By sameery in forum Excel General
    Replies: 3
    Last Post: 05-22-2014, 09:06 AM
  2. Word VBA Activex combobox problem
    By motyl in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2013, 05:39 PM
  3. Owc11 ActiveX z-index problem IE8
    By kayakerboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2010, 03:01 AM
  4. Problem with ActiveX and Matlab Object
    By ondreja in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2007, 03:23 AM
  5. VC problem: add an ActiveX control failed.
    By Dicaprio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2005, 11:35 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