Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Object oriented programming in vba | Excel Programming | |||
Programming a chart object | Excel Programming | |||
Need help with Range object in Macro programming | Excel Programming | |||
Programming code to new object | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming |