userform always on top?

  • Thread starter Thread starter dok112
  • Start date Start date
D

dok112

Hello,

Is there a way to make a userform be always on top? I have a userfor
that is constantly being used, and with there being no icon in th
taskbar, I have to switch screens around constantly. Is there a way t
set up the userform so it is always on top? If not, is there a way t
create a taskbar icon similiar to excel
 
In the View menu, Toolbars, Customize, I selected the
Tools category, then at the bottom of the Commands list,
I dragged and dropped the Custom icon out to the main
menu. Still in the Customize dialog box, I clicked on the
Modify Selection button, assigned the ShowUserForm macro
to the new menu item. Finally, I added a module and
created the following procedure:
Sub ShowUserForm()
UserForm1.Show
End Sub

Hope that gets you started.
Geof.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top