+ Reply to Thread
Results 1 to 3 of 3

Introducing IF in OFFSET with 3 variants

  1. #1
    Registered User
    Join Date
    05-30-2019
    Location
    Köln
    MS-Off Ver
    W10Pro
    Posts
    35

    Introducing IF in OFFSET with 3 variants

    Hi all,

    I need a little help introducing an IF in Offset from the VBA code below.
    There are 3 possibilities, depending on which TextBox are empty[(TU, TA, TP, TR), (QB, QU), PF)]

    Can anyone give me some advice? Thanks in advance!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Introducing IF in OFFSET with 3 variants

    If TU etc have .Value properties, then maybe

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-30-2019
    Location
    Köln
    MS-Off Ver
    W10Pro
    Posts
    35

    Re: Introducing IF in OFFSET with 3 variants

    Hi,

    thanks to your recomandation i do:
    Please Login or Register  to view this content.
    ...and is working. Thanks!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Searching variants vba
    By bdmrn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2020, 12:51 PM
  2. [SOLVED] List Variants
    By confusus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2017, 10:11 AM
  3. [SOLVED] Avoiding Variants: Multiple Declarations per Line Assign Variants To All But Last Variable
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-08-2015, 11:35 AM
  4. Variants of csv file
    By jywll in forum Excel General
    Replies: 0
    Last Post: 02-18-2014, 05:26 PM
  5. Gender Variants
    By ibizian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2013, 05:06 PM
  6. Use of Variants
    By rwgrietveld in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2008, 08:44 AM
  7. Variants vs ranges
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2005, 08:25 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1