Combo box default value

N

Newbie800

When creating a combo box with the listfillrange originating from an external
spread sheet the combo box is blank when the spread sheet is opened. All of
the drop down options are there and the box functions properly including the
linked result cell which gives the last saved value except for the visible
reference.

How do I require that the combo box has text or a value visible from the
last saved position when opened?

Thank you,
 

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

Top