+ Reply to Thread
Results 1 to 2 of 2

Need to check the value in a cell before closing

  1. #1
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Need to check the value in a cell before closing

    Dear Friends
    I have a worksheet where I need to make sure some range is filled with data before saving.
    I will keep a button for save and close and when I click the button it should check the range (for eg A1: B10) and make sure that the cells are not empty and it has some content in it. If any cell within that range is empty, I should get a msg that cell is empty.
    could you please help me to code. I am stuck.
    Thanks
    Appreciate clicking the * Add Reputation button on your left side, if you want say thanks to me

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,915

    Re: Need to check the value in a cell before closing

    Please Login or Register  to view this content.

+ 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. Check Open Workbooks Before Closing
    By ezrizer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-07-2014, 02:52 PM
  2. Creating new workbook, saving as csv and then closing - but closing always fails.
    By ella626 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2014, 10:05 PM
  3. [SOLVED] Macro to check the empty Cells in a row before closing the file
    By dobracik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2013, 07:35 AM
  4. Macros to check if any cell value has changed before closing workbook
    By sasmit0905 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2013, 09:14 AM
  5. Replies: 4
    Last Post: 08-29-2012, 02:45 PM
  6. How to check cell isnt blank upon saving or closing
    By jchamber00 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-29-2012, 04:42 AM
  7. User Form to check data before closing form
    By CityMPLSEmpolyee in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-15-2012, 12:42 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