Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Should be an easy one. Using an Or Syntax.

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to check if a combobox has one of two value before it runs a function.
    I know &, +, is there an Or function that can be applied. I can not seem to find any reference to a syntax to use.
    The following comes back with a typemismatch.
    If combobox1.Text = ("Crit1") Or ("Crit2") Then

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try:

    If combobox1.Text = ("Crit1") Or combobox1.Text = ("Crit2") Then


    It's never too late to learn something new.

    Ricky

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Worked like a charm.
    THANKS

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •