RE: Relatively new to macros

Tech-Archive recommends: Fix windows errors by optimizing your registry

Tom, you are quite correct about the change event. The only answer I can
come up with is the hyperlink suggestion. If the digit or letter entered is
to send the user to different places based on what the digit or letter is, I
am at a loss.

--
Best wishes,

Jim


"Tom Ogilvy" wrote:

without using arrows, mouse, or enter key.

the change event doesn't fire upon a one character entry in a cell.

until you use the mouse, arrows or enter key.

--
Regards,
Tom Ogilvy


"Jim Jackson" wrote:

Would they need to enter text? If selecting a particular cell will always
tke the user to the same location, a hyperlink will work. Right-Click the
cell and select "hyperlink" and follow through.

Or

Private Sub NewWorksheet_Change(ByVal Target As Range)
If Target.Column = 14 And Target.Value >= 1 Then
If Target.Row >= 2 And Target.Row <= 10 Then
Range("Z40").activate
End If
End If
End Sub

The first and second "IF" limits the execution to a specific range of cells.
You can even narrow it down further if need be. ("If Target.Address = $G$15
Then") In fact you can repeat the If / End If with different Column/Row
designations. The macro will cycle through until it hits a positive result
or gets to the end.
--
Best wishes,

Jim


"Brad" wrote:

One small part of a problem that I have is that I have been asked if there
exists a way that a user could enter in a one character value (number or
text) and excel would automatically enter the value and move to a desginated
location - without using arrows, mouse, or enter key.

I figure if there is a way to do it, it would be through a macro.

Currently reading about the "appliciation.onkey"

Any ideas? Thanks for the help?


.

Quantcast