Use update button in the userform to update worksheet data

[charly1988]

i have a sheet name call "items" and have a name ranged call "itemlist" with has 4 columns (itemID, itemName, Country and Description). In my userform i have a label for itemID and 3 textboxes for other item name, country and Description. And Items will be shown in a listbox. If user select an Item from listbox, item details will be populated on textboxes (Item name, country and description). If user click the update button without making any changes to the data then a message has to be shown that there is no changes made or if he leave a field empty it has to be also been shown in a massage that "Can't have the textbox empty". If he has made proper changes and then click the update button, then it has to update the row where itemID populated in Label.

 

[Fluff]

Duplicate to: Update WorkSheet from Userform

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.