+ Reply to Thread
Results 1 to 2 of 2

How to add a value to the last blank cell of a column if it doesnt exist there already.

Hybrid View

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Mumbai, IN
    MS-Off Ver
    Office 365
    Posts
    97

    How to add a value to the last blank cell of a column if it doesnt exist there already.

    i have a textbox, and few radio buttons and check boxes. i want when any of those change on a userform, based on certain string that i attached to every control, ( for example if i click checkbox verification required then it searches in column a, if it has verification required in it or not. if yes then do nothing if no then add verification required to the last blank cell of that column
    Attached Files Attached Files
    Last edited by yoursamrit2000; 01-22-2015 at 07:01 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: How to add a value to the last blank cell of a column if it doesnt exist there already

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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. [SOLVED] Code to exit and not call module if certain ranges are blank
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-07-2014, 09:00 PM
  2. How to exit sub when the cell is blank
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2013, 10:22 AM
  3. Replies: 0
    Last Post: 03-05-2013, 09:22 AM
  4. [SOLVED] Delete blank rows after filter - if no blank rows exit sub
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 10:00 AM
  5. [SOLVED] How do I exit on blank cell?
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2006, 05:15 PM

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