Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 7 down vote accepted

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

share|improve this answer

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

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .