Floating UserForm

[Eric]

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

 

[Guest]

I dont think so

 

[Jon Peltier]

Display it as a non-modal form:

UserForm1.Show vbModeless

- Jon

 

[Eric]

Found it... I just changed the ShowModal property of the form to false.

Thanks

 

[Guest]

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.