Consulting

Results 1 to 3 of 3

Thread: Solved: Active Object

  1. #1
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location

    Solved: Active Object

    Is there a way to know programatically what shape or group of shapes are presently active? Poking around the VBA Object Browser, I did not find anything like "ActiveShape" nor did I find a shape property like "Active" or similar.
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Try this.

    [vba]
    Dim Shp As Variant

    On Error Resume Next
    For Each Shp In Selection
    MsgBox Shp.Name
    Next
    On Error GoTo 0
    [/vba]

  3. #3
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    Quote Originally Posted by DRJ
    Try this.

    [vba]
    Dim Shp As Variant

    On Error Resume Next
    For Each Shp In Selection
    MsgBox Shp.Name
    Next
    On Error GoTo 0
    [/vba]
    thanks. That is an interesting and useful approach
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

Posting Permissions

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