Combo Box Resetting

  • Thread starter Thread starter andym
  • Start date Start date
A

andym

I have a list of names in a range of cells on a spreadsheet.
- To add names I use a text box.
- To delete names I have created a combo box so you can select the
name, then press a command button to delete that name.

However, once the name has been deleted from the spreadsheet, it still
appears in the combo box. How can I reset the combo box to reflect the
updated list on the spreadsheet without having to exit the program?

Regards,

andy...
 
Dick,

many thanks. I have now fixed the problem thanks to your advice. It
was very easy, wasn't it!!

I do add all my names into the range by coding similar to what you
showed. This gets called upon on the form initialising.

I just added the Me.ComboBox1.Clear, then recalled the initial coding
again.

Worked perfectly. I was searching for "Reset", "Requery" etc ...
"Clear" was so simple!!!

Regards,

andy....
 
You must log in or register to reply here.

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

combo box 2
combo box linked to named range 4
Reference Combo Box to Column of Data 1
Using combo box 1
combo box 1
Excel Concatenate Form Name to Parse for function 1
Auto select when using Combo box in worksheet 2
Combo Box question 5

Back
Top