hi,
i have another problem, when a user hits the submit button data is submitted on an excel spreadsheet but its not stopping a user to submit the data only once.

how can i make my code to work in a way that if a user press submits button it shows a msg box informing user that the data has been submitted.

I have tried attaching msgbox buts its not working.