View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Man Utd Man Utd is offline
external usenet poster
 
Posts: 23
Default Move the cursor to a cell in button click event

I have a button would like to do the followings:
User click the button, I want to make a cell to be selected(make it focused)
in a row which is the last row. This last row is not the last row of the
worksheet but the last row of the column who has no value ?

For example:

A B C
Peter 25 11:35pm
John 33 12pm
Mary 23 1:22am

So if the user click the button, the cell A4 should be selected. I want to
simulate as a new record function.