+ Reply to Thread
Results 1 to 2 of 2

Cell Can not be blank

  1. #1
    Registered User
    Join Date
    02-18-2005
    Posts
    44

    Cell Can not be blank

    If a user tabs off of cell A1 to another cell and cell A1 is blank, is there a way to make a box appear that says A1 can't be blank? I have 3 cells that are required on a template that I need this to happen in. Thanks for any help.

  2. #2
    J.Evans.1970@gmail.com
    Guest

    Re: Cell Can not be blank

    Try the SelectionChange event for the worksheet.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address <> "$A$1" Then
    If Sheet1.Cells(1, 1).Value = "" Then
    MsgBox "Cell A1 cannot be blank!"
    Sheet1.Cells(1, 1).Activate

    End If
    End If
    End Sub


+ 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