refresh listbox

[fi.or.jp.de]

Hi All,

I have excel userform, which is connected to access database.

I have customer details in access dabase.

I will search using excel userform, results are displayed in listbox.
I will select the listbox item and update the required details.

If I click save it saves to database. That is working fine.

What I need is, If click save it need to refresh the listbox item with
saved details.

Assumed i listbox showing status as pending, I click on that & change
it to completed. & Clicked save.

It will be updated in access database. I want to reflect the changes
in listbox after the update.


Is this possible. ??

 

[fi.or.jp.de]

what code need to be added to get updated.

 

[fi.or.jp.de]

I am not using linked cell.

the data will populated to listbox from access database.

Once i double click the selected listbox item, it will appear in the
above text boxes, then i will change
the required fields.