userform always on top?
From: Geof Wyght (anonymous_at_discussions.microsoft.com)
Date: 10/10/04
- Next message: Steved: "Can this formula be used in VBA"
- Previous message: Peter: "Re: userform with mailto"
- In reply to: dok112: "userform always on top?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 10 Oct 2004 14:43:33 -0700
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.
>-----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.php?threadid=268004
>
>.
>
- Next message: Steved: "Can this formula be used in VBA"
- Previous message: Peter: "Re: userform with mailto"
- In reply to: dok112: "userform always on top?"
- Messages sorted by: [ date ] [ thread ]
