Intercepting a Tab on Entry

From: Marston (marston_gould_at_mac.com)
Date: 10/15/04 

Date: 15 Oct 2004 12:02:39 -0700

I'm using ActiveCell to make determination of certain actions to take
in a tool.

What I've discovered is that if the user makes an entry into a cell
and hits the Tab key rather than the Enter key, it puts me into a
different cell and a different, undesired action.

How can I intercept the Tab and turn it into a shift?

Thanks in advance.

Marston

PS - has anyone else noticed that the Beta version of Google groups is
no longer updating as frequently as before. I used to be 10-15
minutes, but now I'm not seeing anything for days.

Relevant Pages

  • Re: Columns
    ... > Maybe though you should be using a table in which case you use the tab key ... > to move from one cell to the next. ... > Doug Robbins - Word MVP ... >> How do I move between columns, as in make an entry in one column, then ...
    (microsoft.public.word.docmanagement)
  • Re: movement between cells in excel
    ... Me thinks you gonna' have to "HIT" something. ... Use the TAB key to move to ... the right after an entry and when you want the next line hit ENTER. ... > once I reach the end of my cell, ...
    (microsoft.public.excel.programming)
  • Re: Performing calculation in active cell based on user input
    ... entry area spans columns A:F: ... Private Sub Worksheet_Change(ByVal Target As Range) ... numbers to the format I need in another cell. ...
    (microsoft.public.excel.programming)
  • RE: Word Templates
    ... that you have set forms protection on your template. ... you press the Tab key in the last cell of a table in one of these unprotected ... pressing the Tab key moves to the next ...
    (microsoft.public.word.docmanagement)
  • Re: MoveAfterReturn is tricking me.
    ... The argument Target in the Worksheet_Change event tells you what cell ... > I've got the first column of my worksheet checking to see if the ... > first character of the typed entry is a string or a number. ... > Because of the way that the event trigger seems to work, ...
    (microsoft.public.excel.programming)