+ Reply to Thread
Results 1 to 2 of 2

One macro blocks the other

  1. #1
    Registered User
    Join Date
    05-09-2017
    Location
    Ostrava
    MS-Off Ver
    2016
    Posts
    36

    One macro blocks the other

    I have made a macro that after a double click in columns E and F where I have the dropdown list appear ComboBox with zooming text. But the macro that highlights the row and the column probably blocks this because it does not work.

    Higlighting row and column macro block ComboBox after doubleclick.
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: One macro blocks the other

    As the highligthing row and column macro changes your target value, the Double click macro is not working properly.
    Why would you highlight the selected row and column in the first place? Is it really needed?
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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 auto-fill: Blocks of consecutive decimal numbers with blank row in between them
    By markbs123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2014, 07:04 AM
  2. Macro to fill in signature and date blocks
    By Hambone70 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2013, 11:09 AM
  3. [SOLVED] Password Protection blocks macro
    By rjrcornelissen in forum Excel General
    Replies: 6
    Last Post: 07-31-2012, 09:43 AM
  4. [SOLVED] Macro to copy selected blocks of data not working
    By Authentik8 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2012, 05:06 AM
  5. Using macros to identify blocks of data and summarise those blocks
    By gophbeav in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2012, 04:35 AM
  6. Macro to Summarize daily files by copying blocks from daily files.
    By menoninblack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2012, 07:26 AM
  7. Three With blocks
    By watzmann in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2009, 10:05 PM
  8. Excel 2007 : Title blocks and x+y blocks!!!!!!
    By ginabgirl in forum Excel General
    Replies: 1
    Last Post: 11-10-2008, 05:47 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