By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,564 Members | 804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,564 IT Pros & Developers. It's quick & easy.

How to create a unique survey number in excel using VBA?

P: 1
I am creating an automated questionnaire (form) in excel to be used to entry data. I need to create a unique survey number. The survey number should be linked to a retrieve button. The goal is if entry data person realized he/she made a mistake, they can write a survey number on the cell, and click on the retrieve button to be able to see the data and make the necessary changes overwriting the old entry. Two things are needed:

1. Before the old entry is overwritten, an error message should pop up asking if you want to overwrite the entry.

2. If the same ID entered twice, an error message should pop up asking you to correct the ID.

I am very new to VBA. I would really appreciate help with writing this code.

Thank you
Jul 31 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.