Results 1 to 3 of 3

Thread: bit of excel help

  1. Aug 21st, 2001, 05:01 AM #1
    nswan
    nswan is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2000
    Location
    Reading, UK
    Posts
    870

    bit of excel help

    Hi,

    does Excel VBA have an event procedure that can be used whenever a cell's value is changed?

    Thanks
    Nick
    Reply With Quote Reply With Quote
  2. Aug 21st, 2001, 07:23 AM #2
    nswan
    nswan is offline

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2000
    Location
    Reading, UK
    Posts
    870
    anybody??!!??
    Reply With Quote Reply With Quote
  3. Aug 21st, 2001, 07:55 AM #3
    SeaHag
    SeaHag is offline
    Fanatic Member SeaHag's Avatar
    Join Date
    Jul 2001
    Location
    Lake Huron
    Posts
    901
    I think this will work.


    VB Code:
    1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    2.  
    3. End Sub.

    or

    VB Code:
    1. Private Sub Worksheet_Calculate()

    2.  
    3.  
    4. End Sub

    Mess around

    Seahag
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width