Same userform for multiple sheet entries?
Posted by Garland on January 30, 2001 11:14 PM
I have a 12 sheet cash balancing workbook, part of which is to enter the petty cash on hand. This consists of pennies, nickels, dimes, etc. I have a userform that I am trying to utilize to input this information into each sheet, for each succeeding day. The problem I am encountering is that the userform works correctly for the first sheet. However, when activated for the next sheet, the values from the preceeding sheet still appear in the userform. Changing any value changes the value on the previous sheet. Is there any way to initialize or force the userform to update the activesheet instead of the previous sheet?
Thanks for any help or suggestions...