[drawde]

Hi

I am trying to write some macros in Word, and teaching myself VBA as I go.

Is it possible to use some kind of "or" function with an IF statement?

I want to display a userform if toolbar1 or toolbar2 is visible, but display a different userform if neither toolbar is visible. I can do this if only one toolbar is used:

If CommandBars("Toolbar1").Visible = False Then
Userform1.Show
Else
Userform2.Show
End If

But I need it to run if either toolbar1 or toolbar 2 is visible. Is there some kind of "or" command that I can use? I tried using two separate If statements:

If CommandBars("Toolbar1").Visible = False Then
Userform1.Show
Else
Userform2.Show
End If
If CommandBars("Toolbar2").Visible = False Then
Userform1.Show
Else
Userform2.Show
End If

But this displays both userforms!

Any help would be much appreciated!

drawde

[Jimmy the Hand]

Try this

If (CommandBars("Toolbar1").Visible = True) or (CommandBars("Toolbar2").Visible = True) Then
     Userform2.Show
Else
     Userform1.Show
End If

which is equivalent with

If CommandBars("Toolbar1").Visible or CommandBars("Toolbar2").Visible Then
     Userform2.Show
Else
     Userform1.Show
End If

[drawde]

I never thought to put the "or" there!

Works perfectly, thanks very much!