combo box

[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

 

[Dan E]

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

 

[sox]

That was quick, thank you. I've done that and it works beautifully,
autocompletes and everything.
Sox

 

[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

 

[Dan E]

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

 

[sox]

I did send a thank you for the earlier reply Dan E but its not showing here.

 

[sox]

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