| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox options
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?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
textbox options
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
textbox options
the only problem is that they dont have to go to the other sheet, so i want the user to have the option to click yes or no
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
textbox options
Use msgbox function then
If TextBox1.text = InValidValue Then x = Msgbox("Your Message",vbYesNoCancel If x = vbYes then Sheets("Yes").activat If x = vbNo then Sheets("No").activate End if |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tools options view window options | Excel Discussion (Misc queries) | |||
| Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
| Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
| how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
| UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Linear Mode
