combo box

  • Thread starter Thread starter sox
  • Start date Start date
S

sox

Hi
I'm trying to set up a control toolbox combo box. Have got list entered in
A1:A28. Combo box is in place and formula bar reads
=EMBED("Forms.ComboBox.1","")
How do I get list into box please?
Sox
 
Sounds like your using a combobox from the control toolbox so . . .
In design mode right click the combobox and choose "Properties"
In the ListFillRange enter A1:A28

Dan E
 
That was quick, thank you. I've done that and it works beautifully,
autocompletes and everything.
Sox
 
Hi again
Is it possible to tell a command button (from control toolbox) to delete the
selection made in the combo box so that it's empty and you can start typing
again please?
Thx
Sox
 
Sox,

I'm not sure what you mean?
You should be able to put your cursor in the combobox and type, even if you
have made a selection.
Anyways, i'm not sure how familiar you are with VBA so here goes . . .
In design mode, double click the commandbutton.
It should take you to the code screen where you'll see something like
Private Sub CommandButton1_Click()

End Sub

Just put:
ComboBox1.Value = ""
between the Sub and End Sub

that will work for combobox1 just change the name.

Dan E
 
Dan E

I'm not familiar with VBA at all but I'm learning - quite fast because of
the speed of responses :-)
Thank you for both bits. The combo box and delete button both work so I'm
going to celebrate with a drink before I get over excited.

Have a good weekend
Sox
 
Back
Top