Need help in code to overwite existing data from userform

[MedSter2015]

Hi, I am fairly new to this forum and to VBA.
I have created a userform to recall data from Excel Sheet ("Prospects") in a numnber of fields (textbox, combobox, etc.)
the command button to call the data to userform is CommandButton1

I would like to add another command that will allow me to change/edit certain cell containts and overwite the existing ones... Thank you so much for your help
the code I am using is:

Please Login or Register  to view this content.

[JBeaucaire]

I would like to add another command that will allow me to change/edit certain cell containts and overwite the existing ones...

For instance?

[MedSter2015]

For instance?

Thanks JBeaucaire
In fact, the above code retrieves data from a sheet (all related info are stored in the same row). for example, I enter a client name, contact, email, etc.
I have written the above code to retrieve this info from the excel sheet and display it in the userform (data called by pressing on CommandButton1).
Once the data is called into the userform, I can change some entries, amend, add new info (in pre-set set of columns) and then I would like a code that will allow me re-saving these amended data by overwriting the existing one. so the code should be linked to the lookup function of the above one.

I am not sure if my explanation is too confusing...

Thanks for your help.
PS: the code i use to enter the data in first place is

Please Login or Register  to view this content.

[JBeaucaire]

I see in the second macro you do a line by line check for the prospect (the LOOP) and popup a msgbox warning of duplicates. Instead of that warning, just note that row number where the prospect was found and exit the loop. If you reach the end of the data you can note the next empty row instead. Then your macro continues normally.

[MedSter2015]

Thanks a lot, figured out a code that works as below.

Please Login or Register  to view this content.

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.