VBA UserForm MsgBox Code Amendment

I currently have MsgBoxes that appear on screen when CommandButtons are clicked and then automatically disappear after 2 seconds.


1. 'Update' CommandButton - the MsgBox appears even if no updates have actually been made which is not what I want

2. 'Delete' CommandButton - the MsgBox only appears when an invoice is selected from the ListBox which is what I want.


So my question is:


How do I get the 'Update' CommandButton MsgBox to only appear when an invoice is selected from the ListBox and THEN then 'Update' CommandButton is clicked?


Codes:

'Delete' CommandButton which is working perfectly!

Please Login or Register  to view this content.

'Update' Button which is working, but I would prefer it to only pop up when there is data displayed in the fields for updates to have actually been made

Please Login or Register  to view this content.

Thanks as always!