| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text case question
How can I make the YES in the code below hit even if the text in TextBox1 is
lower case or a mix of both? If TextBox4.Text = "YES" Then OptionButton2.Value = True Else OptionButton1.Value = True End If |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text case question
One way:
If lcase(TextBox4.Text) = lcase("YES") Then If you're careful, you could use: If lcase(TextBox4.Text) = "yes" Then "Patrick C. Simonds" wrote: How can I make the YES in the code below hit even if the text in TextBox1 is lower case or a mix of both? If TextBox4.Text = "YES" Then OptionButton2.Value = True Else OptionButton1.Value = True End If -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
| vlookup -- Upper case and Lower case text | Excel Discussion (Misc queries) | |||
| Select Case question | Excel Programming | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) | |||
Linear Mode
