View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Geof Wyght[_2_] Geof Wyght[_2_] is offline
external usenet poster
 
Posts: 38
Default 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

.