drop down box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I add a blank line or entry in a drop down box?

I would liket to create a item separator other than --------- or __________

Thanks.
 
It depends on which toolbox you're drop down box came from, the Forms toolbox
or the Control toolbox. Right click on your drop down and click on "Format
Control". In the Format Control screen, if there's a Control tab, then,
that's where you specify an input range which becomes the selections in your
drop down. If there is no Control tab, then you can add values through VBA :

ComboBox1.Additem "New Value"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wrapping text around text box 1
Forms with and if/then response? 2
Drop down box behavior 2
Sudden drop in Fibre Broadband Speed 8
Excel Excel: How do I put a formula in a drop down list 11
Forms and drop downs help 8
drop-down list 4
Form Drop Down blank to Access 5

Back
Top