If then Statement

[ptrifile]

I have a label that i am trying to have go to a different URL depending on what a combo box value is. I have the following working:

If Text101.Value = "PC" Then
Label39.HyperlinkAddress = "[URL unfurl="true"]http://www.google.com"[/URL]
End If
If Text101.Value = "HT" Then
Label39.HyperlinkAddress = "[URL unfurl="true"]http://www.cnn.com"[/URL]
End If

What i cannot figure out is how to do the following....if the value is anything other than "pc" or "ht" then nothing happens when it is clicked.

Any suggestions?

Paul

 

[PHV]

Like this ?

If Text101.Value = "PC" Then
  Label39.HyperlinkAddress = "[URL unfurl="true"]http://www.google.com"[/URL]
ElseIf Text101.Value = "HT" Then
  Label39.HyperlinkAddress = "[URL unfurl="true"]http://www.cnn.com"[/URL]
Else
  Label39.HyperlinkAddress = ""
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ptrifile]

Thanks PHV! I tried almost exactly that but didn't have the Elseif in there. Thanks you that worked perfectly!

 

[randy700]

It seems to me that your original code should have done nothing if you didn't have either of those values entered.
What problem were you having?


Randy