Edit existing data in the sheet from Userform

[vignesh_805]

The Userform allows to edit the existing data already in the sheet"MLT".
When the item code (ERP LN) is selected, data related to that particular code populated in the respective field. However, when I edit the data in the field and save it, the new data doesn't gets updated (except the one in column B)

Attached the code below & file

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[vignesh_805]

I went through all the rules and I will take care of it in the coming posts.

Thank you and Sorry !

[torachan]

Give the attached a try, form does 'add new' / 'update' / 'remove'
'Clear' form to activate ready for additions, press 'Add' after filling in details.
The code is compact by virtue of using Table structure.

[dotchiejack]

or if you want to keep your setup.

Please Login or Register  to view this content.

[vignesh_805]

Very helpful and a different approach to the form. Thanks

[vignesh_805]

Solved my case . Thank you Sir !

[vignesh_805]

or if you want to keep your setup.

Please Login or Register  to view this content.

THis code solved my case

[dotchiejack]

Thanks for the feedback and the rep.

[torachan]

I only submitted the alternative because I find it baffling why anyone would do a search when the answer lies in the combobox listindex

[vignesh_805]

or if you want to keep your setup.

Please Login or Register  to view this content.

Hi, unfortunately if NA_addselect = True condition is not adding data to the sheet.

[dotchiejack]

Hi, unfortunately if NA_addselect = True condition is not adding data to the sheet.

yes it does.
The code searches the last used row +1 in the worksheet, In your example you have a value in cell CTN485, When you add new it is added to row 486