Refresh Combobox to reflect new data

**punter1000** · 02-14-2011, 12:12 AM

Hi ...

I have a combobox on a Userform.

The values feed from a series of rows in a spreadsheet dependent on certain criteria.

I can display the correct data, I have the functionality to edit ths data and save it back to the orginal cells, and I can create new records which I can successfully add to a new blank row.

All the above is in perfect working order. (I my opinion!).

However, when I click on the combobox again it fails to pick up the new record, despite my code on the change looking at the full range of cells each time.

Does anybody have any idea how this new data can instantly appear in the combox?

Obviously if I exit the form then reload I can see the new data, but I can't make it occur instantly even though my code searches all records.

Cheers ...

punter

**pike** · 02-14-2011, 12:38 AM

Hi punter1000
Welcome to the forum
What code do you use the populate the combox box on load,
you could add it to a "click event" for the combobox

**punter1000** · 02-14-2011, 01:10 AM

Thanks Pike,

yes, as something as simple as that worked fine!

I actually thought the coding was similar enough to do the same thing between them, but there were subtle differences that didn't allow the full refresh (shows you how tired I am!).

As a hint to anybody else now or in the future reading this post - clear the values from the combobox first before loading or else you get double entries (in my case anyway!).

Thanks once again Pike ... most appreciated!

punter

Refresh Combobox to reflect new data

LinkBack

Thread Tools

Rate This Thread

Display

Refresh Combobox to reflect new data

Re: Refresh Combobox to reflect new data

Re: Refresh Combobox to reflect new data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions