!! userform / variable question !! 
Author Message
 !! userform / variable question !!

Hey all,

The userform that I am using right now is called through a command
button. It collects the username and, if there is one, a guest, and
places that information on certain pages in the workbook(user/guest or
just user). The variables are public so that they can be used
throughout the workbook. Everything works fine if the user goes
through the workbook once, but if they go through more than once (they
need to change information), two different problems have come up:

1) If the user enters information and clicks OK, the userform hides
and the information is placed. If the userform is called again(through
the same button), it appears, containing the same information. If any
information on the userform is changed, and the user presses OK,
nothing in the workbook changes. It is the info that was originally
used to fill the uesrform out.

2) If the button to reset the workbook(erase data in the worksheets
that was gathered from the userform) is pressed, and the workbook is
restarted, the userform pops up with the info last entered. If the
guest is changed, and the OK button is pressed, the worksheets show
the original user and guest plus the new guest (user/old guest/new
guest).

I have looked for ways to reset the variables but couldn't find
anything that worked. I have tried to unload the userform but I get a
message saying "Member or data method could not be found".

I realize that seeing the code would be easier, but there are a few
modules that would have to be posted. Rather than posting all of that
here, I can email it to anyone that is interested....

Thanks so much,

Mike



Sat, 09 Oct 2004 23:48:07 GMT  
 !! userform / variable question !!
Hi Mike,


Quote:
> I realize that seeing the code would be easier, but there are a few
> modules that would have to be posted. Rather than posting all of that
> here, I can email it to anyone that is interested....

You can send it directly to me if you'd like.  I'll take a look when I get a
chance to see if I can help you find the problem.

Regards,

Jake Marx
MS MVP - Excel



Sun, 10 Oct 2004 13:54:57 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Two Questions - Making a userform active / Accessing a userform via a variable

2. Userform variable question

3. Variable(s) Reset by Showing 2nd UserForm on top 1st UserForm

4. Passing a Variable from one Userform to another Userform

5. How do I link a VBA variable to a UserForm text box

6. Pass variable to userform

7. Global variables in userform code

8. VARIABLE value as Userform listbox DEFAULT ?

9. Passing a variable through a UserForm

10. XL97 UserForm entry 2 module variable


 
Powered by phpBB® Forum Software © phpBB Group