+ Reply to Thread
Results 1 to 4 of 4

Prevent text from being entered, if above cell ist empty

Hybrid View

FallingDown Prevent text from being... 01-19-2012, 04:22 AM
Fotis1991 Re: Prevent text from being... 01-19-2012, 04:32 AM
FallingDown Re: Prevent text from being... 01-19-2012, 04:47 AM
Fotis1991 Re: Prevent text from being... 01-19-2012, 04:51 AM
  1. #1
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    364

    Prevent text from being entered, if above cell ist empty

    Hi all

    I have a table useres need to enter data to.
    One line is one event. So for each new event they will have to start a new line.
    Since the table is endlessly long and people might not realize that they are "opening" the new event in a row way down on the sheet, and not below the previous event I'd like to prevent this.
    The first four columns are hidden and contain data for VLookups. The first field to be entered is in in column E. And the first row containing data is row 10 (above that there's a lot of blabla)

    Scenario: Rows 10 to 35 are filled with data.
    Next event would be entered in row 36. But if a user enters the data in row 72 (not realizing this) a whole lot of lines will stay empty. And if someone is looking for this event he might not find it instantly. (Additonal propblem: If the following event would be entered in rwo 36 the "history" would be inconsitent).

    --> So, basicly I am looking for a VBA Code which would chek whether the cell above the first empty cell in column C (after row 10) and if so, return a message box (e.g. "Please enter values in first empty row")

    Any chance of doing this?

    Thx

    FD

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Prevent text from being entered, if above cell ist empty

    Hi

    You need to do this, only with VBA??

    ** Because you can do this, just using Custom Validation.
    Last edited by Fotis1991; 01-19-2012 at 04:39 AM. Reason: **
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    364

    Re: Prevent text from being entered, if above cell ist empty

    Hi Fotis

    Yes, because the Validation is already used for these fields

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Prevent text from being entered, if above cell ist empty

    Thanks for the reply. I have no idea of VBA!! Sorry!!

+ 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