is there a way for a text box to have a yes and no button pop up when wrong information is entered...when you click yes, it takes you to one sheet, if you click no it takes you to another sheet?
Why not just open the sheets based on the return value of textBo
If TextBox1.text = ValidValue Then
Sheets("Yes").activat
Els
Sheets("No").activat
End I
----- Choice wrote: ----
is there a way for a text box to have a yes and no button pop up when wrong information is entered...when you click yes, it takes you to one sheet, if you click no it takes you to another sheet?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
