Setting Form to load once a day

[bensonsearch]

Hi All,

im kinda newish to VB/VBA (used to be good but many years ago). anyways my delema is as follows;

I have a program made in vba for the office for different users on different computers to use. There is 1 form that I want to only appear the first time they run the program each day (the program can be closed and opened again without it showing).

I know i can call it when the main part starts (which is in auto run) but i only want it once a day. Is this even possible??

I can not find anything on google at all.

thanx in advance

 

[Ruddles]

Store the date in a cell somewhere - in a hidden sheet, perhaps.

When the workbook is opened, check whether the cell contains the current date: if doesn't, load the form and store the current date; if it does contain the current date, that means the form has already been loaded that day so don't load it again.

 

[bensonsearch]

OMG that is so genius and simple. I could also do the same with a txt file. thank you so much. from memory the vba function is just "Date" without the marks right?

 

[Ruddles]

The quickest way to test things like that is to create a new workbook, hit Alt-F11 to go to the VBA editor, Ctrl-G to open the Imediate window, and try it there.

Use ? to print, so type ?date and press Enter.