Combo List/Edit or Combo Drop-down/edit

  • Thread starter Thread starter Takeadoe
  • Start date Start date
T

Takeadoe

I've found in the past that when I don't get anyone to bite on my
questions, its because it was a poor question to begin with.
Therefore, I'm going to try and reword this again and simplify it a
bit.

There are LIST boxes, COMBO boxes, COMBO LIST/EDIT boxes, and COMBO
DROP-DOWN/ EDIT boxes.

I have used the drop down boxes. I would very much like to use one of
the COMBO boxes where the user can enter values. I have found no
examples at all on how to create one. Could someone please point me
in the direction of an example?

Also, could someone tell me what is the difference between control and
forms toolbars?


Thanks for all of your help.

Mike
 
The Forms toolbar originated with Excel 5, the first version to support VBA
(released late 1993). Forms toolbar controls were for 'dialog sheets' which
also were introduced with Excel 5 but the controls could also be used on
worksheets.

The Control Toolbox originated with Excel 97 for use with 'userforms', but
some controls can be placed on worksheets.

Forms controls are simpler and more stable on a worksheet. Control Toolbox
controls have more properties and capabilities. I always prefer Forms
controls unless I need a feature only Control Toolbox controls have.

Whenever someone posts a question about a control he should also specify the
toolbar it came from and where the control is being used (sheet versus
userform/dialog sheet). Also some users post questions about 'drop downs'
and it turns out that they are referring to the Data Validation list
feature, so it helps to be very clear about that too.

Sorry, I don't have an example of a combo box in action such as you want.

--
Jim
| I've found in the past that when I don't get anyone to bite on my
| questions, its because it was a poor question to begin with.
| Therefore, I'm going to try and reword this again and simplify it a
| bit.
|
| There are LIST boxes, COMBO boxes, COMBO LIST/EDIT boxes, and COMBO
| DROP-DOWN/ EDIT boxes.
|
| I have used the drop down boxes. I would very much like to use one of
| the COMBO boxes where the user can enter values. I have found no
| examples at all on how to create one. Could someone please point me
| in the direction of an example?
|
| Also, could someone tell me what is the difference between control and
| forms toolbars?
|
|
| Thanks for all of your help.
|
| Mike
|
 
The Forms toolbar originated with Excel 5, the first version to support VBA
(released late 1993). Forms toolbar controls were for 'dialog sheets' which
also were introduced with Excel 5 but the controls could also be used on
worksheets.

The Control Toolbox originated with Excel 97 for use with 'userforms', but
some controls can be placed on worksheets.

Forms controls are simpler and more stable on a worksheet. Control Toolbox
controls have more properties and capabilities. I always prefer Forms
controls unless I need a feature only Control Toolbox controls have.

Whenever someone posts a question about a control he should also specify the
toolbar it came from and where the control is being used (sheet versus
userform/dialog sheet). Also some users post questions about 'drop downs'
and it turns out that they are referring to the Data Validation list
feature, so it helps to be very clear about that too.

Sorry, I don't have an example of a combo box in action such as you want.

--

| I've found in the past that when I don't get anyone to bite on my
| questions, its because it was a poor question to begin with.
| Therefore, I'm going to try and reword this again and simplify it a
| bit.
|
| There are LIST boxes, COMBO boxes, COMBO LIST/EDIT boxes, and COMBO
| DROP-DOWN/ EDIT boxes.
|
| I have used the drop down boxes. I would very much like to use one of
| the COMBO boxes where the user can enter values. I have found no
| examples at all on how to create one. Could someone please point me
| in the direction of an example?
|
| Also, could someone tell me what is the difference between control and
| forms toolbars?
|
|
| Thanks for all of your help.
|
| Mike
|
Click to expand...
Jim - I really appreciate you taking the time to explain the
differences to me. That helps a lot.

Mike
 
Back
Top