Making a form show on startup but only the first time

[Simmerin]

I am new to VB so be nice . I have a form that shows up when you open a workbook, but I only want it to show up the first time the template is opened. If you go back to review the file i dont want it to pop up is that at all possible? Maybe even a radio button you code to make this happen?

 

[wigi]

Hello

Very easy would be to put a 1 in a certain cell, a named range or even a property of the workbook (somewhat less easy).

 

[Simmerin]

Is there a way to maybe put a "do not show this box again" check box like a windows application would do? Plus i dont know how to code what you are suggesting....VERY new to VB hehe.....most of what i have a found guides on and just modified them.

 

[wigi]

Then add a checkbox to the userform. Let's say you name it chkShowAgain.

Then, you write to a certain cell the choice of the user:

ThisWorkbook.Sheets("Sheet1").Range("A1") = me.chkShowAgain.Value

The event Thisworkbook.Open will then have an IF statement:

If ThisWorkbook.Sheets("Sheet1").Range("A1") = True Then
'code to show the userform
End If

But the userform will never come up again once it was turned off using the checkbox...

 

[Simmerin]

thank you much! I'll try it out. This is basically a one time place data where it needs to go to do your initial setup so i really only need it once. I placed a macro on the front page so if i need it again i have access. Thanks!

 

[Simmerin]

Works Perfectly! Thanks Wigi! I did have to change the if to = false though, otherwise it did opposite what i wanted

 

[wigi]

Works Perfectly! Thanks Wigi! I did have to change the if to = false though, otherwise it did opposite what i wanted

Depends on how you phrase the text next to the checkbox