Results 1 to 3 of 3

Thread: VBA using lose focus

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2019

    VBA using lose focus

    I have an excel vba userform that I've set up to be always on top. there's 2 things I'd like to accomplish that I can't figure out how.
    1) minimize the Excel window while the userform is active
    2) when the userfom loses focus (another application has focus) my userform resizes (In effect I want it to mimic a ribbon)
    Possible? Not Possible???
    Last edited by Rominall; Jul 18th, 2019 at 03:52 PM.

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