Hi Guys ,
I use below code for auto filling from a database and it works great. Is there a way that when I press enter key the active cell move by offset(0,1)
(for example from a1 to b1) then when i press enter key again(when in b1) it will move activecell by(1,-1) (from b1 to a2), then after enter key again to b2 and so on..
Many thanks for your help in advance!
Please Login or Register to view this content.
It says this in the help file:
A KeyPress event does not occur under the following conditions:
Pressing TAB.
Pressing ENTER.
Pressing an arrow key.
When a keystroke causes the focus to move from one control to another.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks