Default values for a form in Excel

[Daedelus]

This is probably simple, but I can't seem to locate the right syntax/locations.

I have a workbook with a macro which, at one point in its execution, opens a form for user input. I would like for the last value entered to show up as the default the next time the form is activated, even if the workbook has been closed and reopened between. I would prefer that this saved value not be in a cell somewhere, but instead be invisible to the user.

So far everything I've tried has either not been saved, or the variable is not recognized by the form, which creates it's own variable of the same name instead (whose value is not readable by the calling macro).

I have seen how to do this somewhere, but cannot find it now that I actually need it!

 

[DukeSSD]

Have you tried the Windows forum ? ;-)

 

[Daedelus]

My apologies! I was searching the windows forums for threads relating, and had not realized it sent me back here when I decided to post.