+ Reply to Thread
Results 1 to 4 of 4

Excel VBA to force cell entry if another cell is not empty

  1. #1
    Registered User
    Join Date
    11-11-2013
    Location
    Davao, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    10

    Excel VBA to force cell entry if another cell is not empty

    i believe somebody could help me with this excel spreadsheet that i'm trying to develop. i just don't know how to write the codes and where to place those. i want to force every user of my worksheet to fill say cell b1 if a1 has entry in it and they cannot move to another cell if cell b1 is still blank. i am also trying to activate the code with cell b2 if a2 is not empty. Please also make the code run even the worksheet is protected.


    Thanks for all that may help.

    cedric[/B]

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Excel VBA to force cell entry if another cell is not empty

    Do right click on sheet tab and select view cod and paste the below code. Return to excel and check

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    11-11-2013
    Location
    Davao, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Excel VBA to force cell entry if another cell is not empty

    Thank you very much Sixthsense for the solution. this problem keeps my eyes and head aching for days now. Your help is very much appreciated.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Excel VBA to force cell entry if another cell is not empty

    Glad it helps you and thanks for the feedback and rep

+ 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. code to force cell entry
    By 3earth in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-28-2013, 02:15 AM
  2. [SOLVED] How do you force a cell to appear empty when there is a function in it...
    By Legend Rubber in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-16-2012, 03:12 AM
  3. Excel data entry does not accept empty cell(s).
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2010, 07:39 AM
  4. Force cell entry before move or close?
    By KausBorealis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2008, 05:46 PM
  5. Validation to force entry in a cell
    By Matt D Francis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-04-2005, 10:05 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