Results 1 to 11 of 11

Trigger a macro or worksheet event with a UDF?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-21-2014
    Location
    Midwest USA
    MS-Off Ver
    2010
    Posts
    349

    Trigger a macro or worksheet event with a UDF?

    Attached is an interactive chart I’m working on – to change the chart on the “Interactive Dashboard” sheet, all you have to do is mouse over any small triangle on row 6 between Col B – G. I have 9 stocks assigned to five different categories – the category count is displayed on row four.

    My problem is that while Col E actually only should have two diamonds on the chart, the chart is plotting the first 5 lines on the horizontal access. I can solve this problem by filtering Col H on the “Graph” worksheet for blanks. I have a worksheet_change macro to do just that – if you put your cursor in cell H2 of the "Graph" worksheet and hit enter, you can see that macro works.

    My question is how can I trigger those two lines of code from the UDF? I’ve tried adding those lines to the UDF, Calling them from the UDF and even using the worksheet_change event. None of those work – even though the UDF changes cell H2, the worksheet_change event does not fire.

    Does anyone have any ideas? Appreciate any suggestions. Thanks!
    aquixano
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Worksheet Change Event Wrongly Trigger
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2014, 11:00 PM
  2. Replies: 1
    Last Post: 05-27-2011, 12:27 PM
  3. Macro Trigger/Event
    By 31RHCP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2010, 06:18 PM
  4. [SOLVED] Cell value change to trigger macro (worksheet change event?)
    By Neil Goldwasser in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2006, 10:00 AM
  5. [SOLVED] Trigger macro with keypress event??
    By CarlosAntenna in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2005, 04:05 PM
  6. How to trigger a macro on a worksheet on the event of user-input?
    By fiven in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2005, 11:38 PM
  7. How to auto-trigger a macro on a worksheet on the event of user-input?
    By fiven in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2005, 11:23 AM

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