View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Agee Bill Agee is offline
external usenet poster
 
Posts: 8
Default Check the value of a cell from VBA?

I have been using Worksheet_SelectionChange (ByVal Target as Range) in my
worksheet module but
I need to do the following. Lets assume that we are going to check cell B5
for the following qty/hp (ex 2/5).

I need to examine B5 after the value has been entered and the user has
either used the Enter key or the Tab key.
How do I intercept this event?