use a combobox instead of list box. It works the same except the combobox
allows a manual entry.

" wrote:

Hi All,

I have created UserForm in Excel and added button which will search
all the records in Access database and get the results in a Excel
userform listbox.

I dont have any problem in searching and updating the data into Access
Database.

The main problem is - Assume I have two textbox in userform 1. Name 2.
Dept

Using search option i will get the results in a listbox.

Suppose user wants to change his dept then user selects particular
name in a listbox and will
change the name.
if user updates the changes in my database I can see old data and the
new data.

I want only the new data.

Is this possible,

Please help me !

Thanks in advance