Is there a way to add a counter at the bottom of a user
form created in MS Excel? I have a user form being
utilized as a survey form. The survey is to be taken
by "X" number of people, only one time. I need to
capture the user's input (which I have already done),
however, as a Unique ID Number, I need a counter that
will automatically increase each time the form is
opened. And, once opened then I will write the code to
ensure the same user does not open it multiple times.

I am using Windows XP Professional with FrontPage with a
MS Excel 2002 version. Any ideas? Thanks in advance