rharri1972
Board Regular
- Joined
- Nov 12, 2021
- Messages
- 132
- Office Version
- 2019
- Platform
- Windows
Hello!
I have 4 Textboxes on Userform1
Textbox1 = Part Number
Textbox2= Description
Textbox3= Vendor
Textbox4= Price
Once the data is manually placed in the textboxes I have an "OK" command button that will search out the next available row to place this data on worksheet "Inventory".
However, I do NOT want any data moved to the worksheet unless ALL textboxes have a value.
On my button click...
What I would like to do is say if ANY of the textboxes are blank or empty or ="", whichever is proper, Then do not add data to worksheet until all textboxes have a value.
I would also like to call out by msgbox the value needed for any blank textbox, for example, lets use Textbox 2 in this case. If Textbox2 is blank, and it's value is "Description", then I would like to have a msgbox prompt stating to "Please enter part description" or whichever "value" message would coincide with each textbox.
Once all textboxes have a value then I would want the data to transfer to the worksheet.
Also, is there a way to validate or confirm that the data was "pasted" or "sent" to that row on the sheet prompting a msgbox something like "New part added successfully"?
Any help will be greatly appreciated.
I have 4 Textboxes on Userform1
Textbox1 = Part Number
Textbox2= Description
Textbox3= Vendor
Textbox4= Price
Once the data is manually placed in the textboxes I have an "OK" command button that will search out the next available row to place this data on worksheet "Inventory".
However, I do NOT want any data moved to the worksheet unless ALL textboxes have a value.
On my button click...
What I would like to do is say if ANY of the textboxes are blank or empty or ="", whichever is proper, Then do not add data to worksheet until all textboxes have a value.
I would also like to call out by msgbox the value needed for any blank textbox, for example, lets use Textbox 2 in this case. If Textbox2 is blank, and it's value is "Description", then I would like to have a msgbox prompt stating to "Please enter part description" or whichever "value" message would coincide with each textbox.
Once all textboxes have a value then I would want the data to transfer to the worksheet.
Also, is there a way to validate or confirm that the data was "pasted" or "sent" to that row on the sheet prompting a msgbox something like "New part added successfully"?
Any help will be greatly appreciated.