View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Shaka215@gmail.com is offline
external usenet poster
 
Posts: 162
Default How do I get Excel to jump to the next row using VB code?

Hello!

I am in need of some code that will allow an end-user to jump to the
next text entry area in a locked spreadsheet (go to the next unlocked
row). I tired to use OFFSET(x,x) but that didn't seem to want to jump
to the next text entry area but to just move off to the OFFSET values.
I am assuming it would be like hitting the ENTER key but I tried using
SENDKEY commands to but that didn't work either...so I am completely
stumped on this one. I basically need Excel to recognize the fact that
the locked feilds can not be entered into only the unlocked feilds are
where the end-user will type information into....Any help is much
appreciated!!

EXAMPLE

NAME: John Smith (B3) - Unlocked

* * END USER PRESSES BUTTON THAT JUMPS TO THE NEXT UNLOCKED CELL * *

ADDRESS: 120 FROG LANE (B12)

* * END USER PRESSES BUTTON THAT JUMPS TO THE NEXT UNLOCKED CELL * *

CITY: POKERTOWN (B13)

* * END USER PRESSES BUTTON THAT JUMPS TO THE NEXT UNLOCKED CELL * *

ZIP: 55511 (B14)

* * END USER PRESSES BUTTON THAT JUMPS TO THE NEXT UNLOCKED CELL * *

STATE: AZ (B15)

* * END USER PRESSES BUTTON THAT JUMPS TO THE NEXT UNLOCKED CELL * *

PHONE: ????????????? (UNKNOWN LOCATION BUT WILL BE A UNLOCKED CELL)