What is the difference between Button (Control toolbox toolbar) and Command Button (Forms toolbar)?
In writing out what I know about the two, I've discovered I know more about them than I thought, so perhaps my question should be, "Are there any other differences between them, and are there any particular advantages of using one over the other?"
Also, what other useful OLEObjects can be added? Is there a list of keywords somewhere?
Button
- created by VBA statement:
WS.OLEObjects.Add(ClassType:="Forms.CommandButton.1" left:=...)
- must be in design mode to edit
- can view/edit properties via VBA properties window
Command button:
- created by VBA statement:
WS.Buttons.Add(left, top...)
- is a shape
- user can always move/edit (assign macros, etc)
In writing out what I know about the two, I've discovered I know more about them than I thought, so perhaps my question should be, "Are there any other differences between them, and are there any particular advantages of using one over the other?"
Also, what other useful OLEObjects can be added? Is there a list of keywords somewhere?
Button
- created by VBA statement:
WS.OLEObjects.Add(ClassType:="Forms.CommandButton.1" left:=...)
- must be in design mode to edit
- can view/edit properties via VBA properties window
Command button:
- created by VBA statement:
WS.Buttons.Add(left, top...)
- is a shape
- user can always move/edit (assign macros, etc)
