modeless userform

  1. D

    How to set the start position of a modeless user-form?

    Hello all. I know how to position a modal form, but a modeless form, acting as a 'please wait' sign is not responding in the same way. If anyone can help I would be very grateful. I position a regular form with the following private sub in the forms code window Private Sub UserForm_Activate()...
  2. M

    set actions for gain/ loss focus on modeless userform

    Hi, I have a Modeless userform, I want to run a code when UF losses its focus to excel worksheet and also another code runs when it gain focus. My actual concern is when I am changing the current worksheet. I want to reload the comboboxes values based on the new sheet data. Can anybody help...
  3. D

    Modeless userform won't stay on top when event code is added through VBA

    My macro creates a simple modeless userform that lists all the worksheets as labels and assigns macro to each label to switch the activesheet when user clicks a worksheet name on the userform. Everything is done through vba. The problem is that the userform doesn't stay on top after macro ends...
  4. J

    Trouble with Disappearing UserForms when Running VBA Code to Delete Unneeded Worksheets

    Hello. This is my first post so thanks for your patience. Prior to posting this thread I have exhausted many hours on multiple forum websites, Excel VBA books and other help resources. I'm spent. COMPUTER/SOFTWARE: I'm working on a US Military PC (Windows 7 Enterprise, Service Pack 1 // MS...
  5. A

    Bring focus back to a Modeless UserForm - Solved

    Note: An idea of how to fix this occured to me after I typed this up, so this issue is solved for me. I decided to post it anyway since it might be useful to someone else. The solution is at the bottom of this post. Greetings, This is what I think should be a simple problem but I can't seem to...
  6. T

    Modeless Userform using .Show vbModeless started triggering Type Mismatch Error 13

    Hello all, Thanks in advance for any suggestions! A little background: I've been tinkering with VBA for 3-4 years now starting with VBA for Dummies, moving on to Mr Walkenbach's Excel 2007:Power Programming with VBA, and have just recently gotten into Professional Excel Development: The...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top