MessageBox verification restricts textbox entry.

[Gal403]

Hello,

I've created a Message Box asking the user to enter two textbox fields before proceeding to add the rest of the data to a spreadsheet. The same ADD button will add the driver name "Dave" to respective cell in the spreadsheet. I don't know how to include in the cmdAdd procedure to prevent the Drivers name "Dave" from adding after the two mandatory fields - txtVendor and txtLocation - are filled. Similarly, values entered in txtFruit and txtVeggie are filled and entered in the respective cell even if the mandatory textboxes - txtVendor and txtLocation - are not filled.

Can someone suggest a code?

Sample userform is included.
thanks in advance.
Gal

Sample 3 MsgBox.xlsm

[jaslake]

Hi Gal03

It may be as simple as this

Please Login or Register  to view this content.

[Gal403]

John, Thank you!!

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.