| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a counter to a User Form in Excel
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a counter to a User Form in Excel
Pam
It is possible to add a counter, but I fail to see how this will stop someone from running it again. I'd be tempted to either a) get their logged on username via an API call, or b) store something in the registry after the program has finished, and check for this when the program starts. Let me know what you think -----Original Message----- 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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding a counter to a User Form in Excel
Either option, I just have to have a way to track users,
an ensure they only complete form once. I am not familiar with API calls. -----Original Message----- Pam It is possible to add a counter, but I fail to see how this will stop someone from running it again. I'd be tempted to either a) get their logged on username via an API call, or b) store something in the registry after the program has finished, and check for this when the program starts. Let me know what you think -----Original Message----- 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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding items to a combo box on a user form | Excel Discussion (Misc queries) | |||
| Adding Counter to column for number of identical file numbers | Excel Discussion (Misc queries) | |||
| Adding a new text box to user form | Excel Discussion (Misc queries) | |||
| Adding items to a spreadsheet from a user form listbox | Excel Programming | |||
Linear Mode
