View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Which method to use

That is because the forms toolbar controls are more worksheet integrated as
I mentioned, everything (VBA aside) is done from within the worksheet within
Excel.

Controls toolbox are not so integrated, and most things are done from within
the object properties. The right-click options are just those needed to
'connect' the control with the worksheet.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Epinn" wrote in message
...
I am not familiar with either but I have noticed one difference between the
two.

When I right-click on the shape/box/control (e.g. combo box) and click
format control, the number of tabs are different.

Forms = 5 --- size, protection, property, web, control
Control Toolbox = 4 --- size, protection, property, web

No clue why.

Epinn

"Bob Phillips" wrote in message
...
The forms toolbar is simplest, and is probably best integrated into Excel.

The control toolbox is harder to work with, but offers more flexibility
(such as background colour of controls).

Use the one you are comfortable with. Personally, I don't like controls on a
worksheet, I prefer trapping events, or adding toolbar buttons.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Arran" wrote in message
...
You can add a control to a Workbook/ Worksheet by either the Forms Toolbar
or
the Control Toolbox. My question is which simply which method is used.