Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers

up vote 6 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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.