Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating UserForm
Hello,
I would like to create a UserForm that stays on top of the desktop when loaded but still allows be to interact with the cells and sheets. This UserForm will help me change cells format or permute cells on the fly, almost like a floating toolbar. Thank you. Eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating UserForm
I dont think so
"Eric" wrote: Hello, I would like to create a UserForm that stays on top of the desktop when loaded but still allows be to interact with the cells and sheets. This UserForm will help me change cells format or permute cells on the fly, almost like a floating toolbar. Thank you. Eric |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating UserForm
Display it as a non-modal form:
UserForm1.Show vbModeless - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Eric" wrote in message ... Hello, I would like to create a UserForm that stays on top of the desktop when loaded but still allows be to interact with the cells and sheets. This UserForm will help me change cells format or permute cells on the fly, almost like a floating toolbar. Thank you. Eric |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating UserForm
Found it... I just changed the ShowModal property of the form to false.
Thanks "Mike" wrote in message ... I dont think so "Eric" wrote: Hello, I would like to create a UserForm that stays on top of the desktop when loaded but still allows be to interact with the cells and sheets. This UserForm will help me change cells format or permute cells on the fly, almost like a floating toolbar. Thank you. Eric |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating UserForm
Maybe you can create a user form and set the ShowModal property to False.
But it's probably easier to create your sub routines or macros in your personal workbook and assign them to buttons in a custom toolbar. -- Hope that helps. Vergel Adriano "Eric" wrote: Hello, I would like to create a UserForm that stays on top of the desktop when loaded but still allows be to interact with the cells and sheets. This UserForm will help me change cells format or permute cells on the fly, almost like a floating toolbar. Thank you. Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm as a tool bar/ floating options for excel sheet | Excel Programming | |||
What to use for floating help? | Excel Programming | |||
Floating toolbar and floating comment? | Excel Programming | |||
Floating userform | Excel Programming | |||
'Floating' UserForm | Excel Programming |