How do I enter values in a Combo Box with Excel

[James-pps]

Hi,
I'm struggling to enter values into a Combo Box, I understand that I need to
Script it, but can't work out how! I've tried using the Help function in VB
section but to no avail.

Thanks
James

[davesexcel]

where did you get the combo box from??

Control ToolBox
or
Forms ToolBox

Make a list in your worksheet
Name the list by highliting it and then goto=>insert=>name=>define
put a one word name in the name box
if you used the combo box from the controll toolbox then..
right click on the combobox select properties, find rowsource and enter the named range, now your box is populated,

Combobox from the forms toolbar,
rightclick on the combo box
select format control
select the control tab
input range, enter the range name or you can just click on the squarde button and go to the range and highlite it and click ok

If you are using a combo Box for a UserForm you can populate it the same way as the first explaination,
select the combobox on the userform, be sure it says combobox on the properties window, go down to row source and enter the name of the range

[Chip Pearson]

James,

Try some code like the following:

With UserForm1.ComboBox1
.AddItem "a"
.AddItem "b"
.AddItem "co"
End With



"James-pps" <[email protected]> wrote in
message
news:[email protected]...
> Hi,
> I'm struggling to enter values into a Combo Box, I understand
> that I need to
> Script it, but can't work out how! I've tried using the Help
> function in VB
> section but to no avail.
>
> Thanks
> James

[James-pps]

Thanks, I've tried that but when I click the arrow, I get a blank dropdown
line.

However I have found a way of doing it, instead of selecting a Combo Box
from the Control Toolbox, I inserted one from the Forms Toolbox. Then I could
right click on the object, select Format Control, and then under the control
tab, enter an input range for criteria.

Thanks for your prompt reply

James

"Chip Pearson" wrote:

> James,
>
> Try some code like the following:
>
> With UserForm1.ComboBox1
> .AddItem "a"
> .AddItem "b"
> .AddItem "co"
> End With
>
>
>
> "James-pps" <[email protected]> wrote in
> message
> news:[email protected]...
> > Hi,
> > I'm struggling to enter values into a Combo Box, I understand
> > that I need to
> > Script it, but can't work out how! I've tried using the Help
> > function in VB
> > section but to no avail.
> >
> > Thanks
> > James
>
>
>

[OverAC]

Dears

And I wonder how we can choose the combobox to enter without using mouse.

Regards.
OverAC