+ Reply to Thread
Results 1 to 3 of 3

Click event ceased to work

  1. #1
    Registered User
    Join Date
    10-04-2011
    Location
    Salem, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    60

    Click event ceased to work

    The following code was inserted on Sheet 1....Supposed to add a check mark in any empty cell in Col 5 or clear the cell if a check mark is already there when that cell is clicked.
    It worked for a couple of months but no longer is working. Nothing has changed in the workbook that I can see...need some help here....
    TIA Don

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Click event ceased to work

    As far as I can see there's nothing wrong with this code; at my end this is working.
    Perhaps you could upload a workbook containing this code where the error is produced?

    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,026

    Re: Click event ceased to work

    I tidied up the code a bit. Give it a try.
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ 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. Range specified on Before Double Click event does not work
    By antros48 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2019, 09:06 AM
  2. [SOLVED] ActiveX combobox click triggers unwanted another comboxbox click event
    By aprildu in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-12-2015, 10:08 AM
  3. [SOLVED] Click event fires but doesnt work under initialze procedure
    By kmakjop in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2014, 02:40 PM
  4. Click v double click event code
    By Greg J in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2014, 04:08 AM
  5. Prevent ListBox Click Event Until Mouse Click
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2011, 12:23 PM
  6. Code ceased to function
    By maruchi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-09-2010, 01:04 PM
  7. [SOLVED] userform label double-click goes to click event
    By John Paul Fullerton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2006, 01:00 PM

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