Hey Dave,

Thanks for the reply and the good insight, it is greatly appreciated.

I find only one thing wrong with the Forms ComboBox. I can't type
into it, I can only scroll though it. With 3000 records to scroll
though, it takes some time. My data entry person does not like to
fill in that sheet form, so I built him a UserForm that makes the
sheet form for data entry obsolete. It is shill used as a printing
template to print hard copies of the customers info.

It is working for the most part now, but I think I'll try to use the
Toolbox ComboBox just to see if I can. <G

Thanks also to Gord and JLGWhiz for adding to this discussion

-Minitman
On Tue, 01 Jul 2008 21:43:27 -0500, Dave Peterson
wrote:

Just some more info...

Personally, I like the controls from the Forms toolbar when I put them on a
worksheet. They seem better behaved than the controls from the Control Toolbox
toolbar. Less things go wrong -- especially when there are lots of controls on
the worksheet.

Another nice thing about the controls from the Forms toolbar is that I can
assign the same macro to any of the controls. So if I have a bunch of
checkboxes or buttons that do almost the same thing, I can create one macro and
do a little branching based on what checkbox/button was clicked. Then do the
common work.

Besides all the properties and events that I can use with controls from the
control toolbox toolbar, it also makes life a bit simpler to copy sheets between
workbooks. The code that I use for these controls is placed under the
worksheet. That means that code will travel with the worksheet when it's moved
or copied.

On the other hand, the code for macros for those controls from the Forms toolbar
is located in a General/Regular/Normal (different names for the same thing!)
module. That means that moving/copying a worksheet with a control that has a
macro assigned to it will also have to have that macro copied to a general
module in the receiving workbook's project.

This isn't too difficult to manually, but with all the security excel has added
over the years, maybe be impossible to do in code.



Minitman wrote:

Greetings,

I noticed that there are three different ComboBoxes available.

The one in the Visual Basic Editor, the one in ViewToolbarsControl
Toolbox and the one in ViewToolbarsForms.

I was wondering if anyone could tell me what are the pros and cons of
each type?

I would really appreciate any comments on this question.

-Minitman