Results 1 to 6 of 6

Thread: Prevent code from moving a picture in cell outside of specified range

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    Have look at the attached.
    Different method to move things around, no selecting.
    Look at the named ranges:
    TheBee, a cell in a hidden column containing the picture of the bee. Stays put.
    AllowedRange, the cells the bee is allowed to go in.
    ImHere, the current location of the bee, also contains the formula =TheBee.
    The movement of the bee is also restricted by the drawn cell borders.
    Currently, instead of resetting to the start, a noise is made.
    If the bee lands on the rose, the rose is gone, so I haven't included the rose in the AllowedRange.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Tags for this 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
  •