LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Object oriented programming in vba M1kehailu Excel Programming 9 February 17th 09 06:56 PM
Programming a chart object Phil Stanton[_2_] Excel Programming 3 June 9th 08 01:14 PM
Need help with Range object in Macro programming Dan[_49_] Excel Programming 4 October 19th 06 07:26 PM
Programming code to new object Martin Excel Programming 12 August 9th 05 10:45 AM
Confusion about how the Window object fits into the Excel object model Josh Sale Excel Programming 11 April 15th 05 06:08 PM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"