+ Reply to Thread
Results 1 to 2 of 2

Callbacks don't work when editing a cell?

  1. #1
    Registered User
    Join Date
    02-18-2019
    Location
    Austin, TX
    MS-Off Ver
    Office 365
    Posts
    26

    Callbacks don't work when editing a cell?

    Hello,
    I have some buttons with VBA callbacks. I've noticed that when I am actively editing a cell, then pushing those buttons does not trigger the VBA callbacks. So, things like toggle buttons get out of whack, because their toggle states visibly do change - but the subs they are supposed to run do not get called.

    This seems like a big problem. How do you handle that? Is there a way to just disable the buttons when editing a cell?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Callbacks don't work when editing a cell?

    Is there a way to just disable the buttons when editing a cell?
    For some reason a MouseMove event is disabled but a click event is not. I wonder why Excel handles them differently

    Unable to replicate your problem (office 365)
    - button behaves the same whether a cell is in edit mode or not

    This is what I have been trying
    Please Login or Register  to view this content.
    Try a very simple macro to see if it runs
    - if it does then work out what else is happening to prevent your current macros from running
    Last edited by kev_; 02-23-2019 at 06:31 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

+ 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. Editing a vba script to work with different columns
    By Mr_Bill in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-03-2014, 12:17 AM
  2. Editing the connection string doesn't seem to work
    By PMBTech in forum Excel General
    Replies: 0
    Last Post: 08-11-2014, 11:00 AM
  3. callbacks in VBA & wait/sleep
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2014, 07:40 AM
  4. Editing combo box VBA to work with 2 sheets instead of the same sheet
    By Pharmboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2014, 11:48 AM
  5. [SOLVED] Editing an importing macro to make it work for a different use.
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2012, 09:43 AM
  6. Findinding & Editing Last used row of multiple work sheets
    By nm766 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2011, 04:18 AM
  7. editing work schedule
    By sendtobrad in forum Excel General
    Replies: 1
    Last Post: 01-10-2010, 05:10 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