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"
 
Back
Top