View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Object programming in Excel

A userform has two modes modal and modeless. I think you want modeless. The
uwserform I'm referering to is not on the worksheet. Go to VBA and add a
userform. Put a couple of controls on the user form. The go to a VBA module
and run the userform. The first userform will automatically be called
userform1.

Sub Main

userform1.show

end main

[object.]Show modal



Settings

The settings for modal a

Constant Value Description
vbModal 1 UserForm is modal. Default.
vbModeless 0 UserForm is modeless



"Scott" wrote:

I have made several userforms. Why?
I was playing around with a command button to represent a cart and one
thing I noticed is that you can not select them and move them around
easily (with out being in design mode). I think I would like to have
the user be able to move the carts around manually if needed. I am
thinking of creating named ranges for each machine and then move the
carts into the named range area. I would have a sub to sort and stack
them at each machine and each would have a seperate que number to
control the order in which they move on to the next machine.