How to make an Excel userForm stay on top

3

I have a userForm and I would like for it to stay on top of my spreadsheet even when I click within the sheet. Is there some code or a setting that I can use to do this? If so where do I put it?

Mike

Posted 2011-09-29T15:15:54.073

Reputation: 297

Answers

7

In the form's properties set the ShowModal to False, and load the form on the workbook opening or worksheet activation. This allows you to work on the worksheet even if the form is showing.

enter image description here

datatoo

Posted 2011-09-29T15:15:54.073

Reputation: 3 162

0

This is the case by default and always. UserForms will always stay on top of worksheets.

The nuance here is in the ShowModal property of the UserForm. By default the ShowModal property of a UserForm is set to True.

When ShowModal is set to...

  • True - Form stays always on top and user cannot edit or select spreadsheet
  • False - Form stays always on top and use can edit and select spreadsheet

enter image description here

ak112358

Posted 2011-09-29T15:15:54.073

Reputation: 563

Asked: 2011-09-29T15:15:54.073

Viewed: 15 164 times

Active: 2011-09-30T18:59:45.230