View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Abraham.Olson@gmail.com is offline
external usenet poster
 
Posts: 28
Default UserForm as a tool bar/ floating options for excel sheet

Nevermind, just figured out the modeless option.

-Abe

wrote:
I am creating a program where I need a variety of buttons and check
boxes that do stuff to the excel sheet. Just using the excel forms
doesn't work because when I zoom out (which the program needs to be
able to do), the buttons get small and unreadable.

So, I would like to be able to create a floating toolbox that has the
buttons and checkboxes in it. I tried a UserForm, but it seems that the
userform requires itself to be deactivated before excel can calculate
anything. Is there any way to have a userform where the worksheet can
be calculated (I am using manual calculation) while the userform is
still up and active).

The goal is to have a floating Start/Stop button that controls whether
or not the worksheet is calculating or not.

Thanks in advance,

Abe