+ Reply to Thread
Results 1 to 2 of 2

message to delete value in cell

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    message to delete value in cell

    Hi..

    I would take a message whenever the User tried to delete any value in any worksheet cell.

    If you chose OK then the cell would be deleted if you chose to Cancel the cell will not be deleted.

    Thanks to all
    Last edited by marreco; 01-08-2012 at 07:45 PM.

  2. #2
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: message to delete value in cell

    I'm thankful for any help .. thanks

    see..
    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    With Target
    If .Cells.Count = 1 Then
    If .Value = vbNullString Then
    If MsgBox("Delete OK?", vbOKCancel) = vbCancel Then
    Application.Undo
    End If
    End If

    End If
    End With
    End Sub
    Last edited by marreco; 01-08-2012 at 07:46 PM.

+ 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