breynolds0431
Active Member
- Joined
- Feb 15, 2013
- Messages
- 303
- Office Version
- 365
- 2016
- Platform
- Windows
Hello. I have a userform that will launch on worksheet activate if certain conditions are met. So, it doesn't need to launch on workbook_open. But the user will move throughout the workbook to various other tabs and will need to revisit this tab that will show the userform. Basically, the userform is a message box. I would have used a message box, but the information within is quite voluminous. So, I'm looking for something that will limit the userform to launching only one time until it's saved or closed (i.e.; show once per session). Is there a way to count the number of times the userform is shown in a session and then use an if statement to limit it from showing more than once?