Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Hasselt
    Posts
    1

    Unanswered: Excel Previous Selected Cell VBA

    Hey,

    I want to go back to my previous selected cell, in wich I had just entered a new value. After that I want to do a control in on this entry. How do I have to take that in my VBA code (so to select that cell again)?

  2. #2
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    You can use SheetChange method. This mothod will fire everytime you make some change.....


    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    MsgBox "Row:" & Target.Row & " Column:" & Target.Column
    End Sub



    if you need it just for checking entered value, maybe VALIDATION would do your job.... go to TOOLS-VALIDATION or use VBA Validation Object - it's the same.




    jiri
    Last edited by playernovis; 04-12-03 at 00:40.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •