userform always on top?
 

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

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=26800

userform always on top?
 

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 procedu
Sub ShowUserForm()
UserForm1.Show
End Sub

Hope that gets you started.
Geof.

-----Original Message-----

Hello,

Is there a way to make a userform be always on top? I
have a userform
that is constantly being used, and with there being no
icon in the
taskbar, I have to switch screens around constantly. Is
there a way to
set up the userform so it is always on top? If not, is
there a way to
create a taskbar icon similiar to excel?


--
dok112
---------------------------------------------------------
---------------
dok112's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=10581
View this thread:
http://www.excelforum.com/showthread...hreadid=268004

.