charly1988
New Member
- Joined
- Jul 31, 2022
- Messages
- 13
- Office Version
- 2016
- Platform
- Windows
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.