Results 1 to 2 of 2

Thread: [RESOLVED] Excel - Event on Embedded Check Box

  1. #1

    Thread Starter
    Fanatic Member Mindcrime's Avatar
    Join Date
    Jun 2001
    Location
    Peterborough, UK
    Posts
    555

    [RESOLVED] Excel - Event on Embedded Check Box

    I have added n Check Boxes to my Spreadsheet.

    I need to be able to call procedures when one has it's value changed.

    How do I reference a controls Click/Change event when it was added with code?

    Could anyone help me out with this?
    Last edited by Mindcrime; Apr 19th, 2004 at 04:15 AM.
    Mindcrime : )
    ICQ 24003332

    VB 5.0, VB 6.0 SP5, COM, DCOM, VB.NET Beta 2, Oracle 8

  2. #2

    Thread Starter
    Fanatic Member Mindcrime's Avatar
    Join Date
    Jun 2001
    Location
    Peterborough, UK
    Posts
    555

    Cool ...simple!

    Create a Module with the procedure you want to fire on any action.
    Code:
    Selection.OnAction = "Module1.IPClick"
    In your Module trap the caller
    Code:
    For Each myCheckBox in ActiveSheet.CheckBoxes
        If myCheckBox.Name = Application.Caller then ...
    Next
    Last edited by Mindcrime; Apr 19th, 2004 at 04:11 AM.
    Mindcrime : )
    ICQ 24003332

    VB 5.0, VB 6.0 SP5, COM, DCOM, VB.NET Beta 2, Oracle 8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width