| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
usings contains in var check
Hi Bruce,
Try something like: Sub Test01() Dim myVar As String ' myVar = "myfile01203" If Len(myVar) 0 Then 'do something, e.g. MsgBox myVar Else 'do something else? End If End Sub --- Regards, Norman "Bruce" wrote in message ... How do I check that a variable 'contains' something? eg. myVar = "myfile01203" If myVar contains "myfile" then 'do something End if |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Usings Text fields in a Pivot Table | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| how can I perform trig. functions usings grads 400deg per circle | Excel Worksheet Functions | |||
Threaded Mode
