+ Reply to Thread
Results 1 to 3 of 3

Check if an entry exists in a column before entering data

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Check if an entry exists in a column before entering data

    Hi,

    I have a userform that basically uses:

    Please Login or Register  to view this content.
    However before these steps I would like a to be able to check if an entry exists in Offset(0, 4) for example if so then omit that line of code but still add the rest.

    Is this possible?

    Thank you in advance.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Check if an entry exists in a column before entering data

    Hi

    Please Login or Register  to view this content.
    see how that goes.

    rylo

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Check if an entry exists in a column before entering data

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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