+ Reply to Thread
Results 1 to 2 of 2

Using VBA to error check multiple cells

  1. #1
    Registered User
    Join Date
    05-24-2014
    Posts
    1

    Using VBA to error check multiple cells

    I'm extremely new to VBA but need to use it to complete error checking, consisting of just a popup message, for an excel spreadsheet. Looking through the forums I found a code that works for one of the cells, but i need it to work for 100 cells (in a single column).
    The code is:

    Please Login or Register  to view this content.
    I was hoping someone could alter this to allow for I3 - I100, any help would be appreciated.

    Moderator's Edit: I added code tags for you since you are new to the forum. Please read our rules and adhere to them in the future.
    Last edited by alansidman; 05-24-2014 at 10:46 AM. Reason: code tags

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Using VBA to error check multiple cells

    Try this instead:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. possible to check for file in multiple folders, then check for values in specific cells?
    By mattheritage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 08:33 AM
  2. [SOLVED] Exact check for multiple more than two cells
    By kbka in forum Excel General
    Replies: 3
    Last Post: 08-16-2012, 06:57 AM
  3. [SOLVED] Error check to see if cells are filled in
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2012, 05:59 PM
  4. Replies: 2
    Last Post: 12-18-2009, 05:20 PM
  5. [SOLVED] How to check multiple cells
    By Sharon Mann in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2006, 10:40 AM

Tags for this Thread

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