View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
stevebriz stevebriz is offline
external usenet poster
 
Posts: 195
Default userform open when sheet activated

Try this
In your useform1 ( assuming this is you welecome form)

put
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Sheets("Criteria").Range("A93").Value = "SHOW"
Else
Sheets("Criteria").Range("A93").Value = ""
End If
End Sub


Then in This Workbook put

Private Sub Workbook_Activate()

If Sheets("Criteria").Range("A93").Value = "SHOW" Then
UserForm1.Show
Else
End If
End Sub


ADK wrote:
A93 of the Criteria sheet

"stevebriz" wrote in message
ups.com...
where do want store whether the user wants the welcome window to show?
on a hidden sheet in a particular cell.( cell value ( true or False)?

ADK wrote:
I would like to open a userform (WelcomeWindow) when the worksheet
(Criteria) is active.

I would also like to place a checkbox on userform that allows a user to
check it to indicate they no longer want the userform to appear.

thanks

adk