Help with code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created and coded text-boxes ( using the design view and VB-code) in excel that enables me to jump from one text-box to anoter by using the Tab-button, but view of the worksheet does not follow the tab

Then I got at tip to add code to Select or GoTo a nearby cell before the textbox

I am a very new user so I am not so familiar with VB code yet
Is it possible to get some help with the code please

Thanks
 
If you want to center a particular cell on your screen, and/or a TEXT box
near that cell, then do F5 and type IV65000 in the reference box and then do
F5 again and type a cell number in the Reference: box that is about 7
columns to the left of your target cell and about 15 rows above it. If your
target was O54 for example, the GOTO cell would be H39.........Excel will
put H39 in the upper left hand corner of your screen and that automatically
puts O54 approximately in the center..............this process can be
automated of course by Recording a Macro while you're doing
it...........that will generate the code for you...........

hth
Vaya con Dios,
Chuck, CABGx3


SOSK said:
I have created and coded text-boxes ( using the design view and VB-code)
Click to expand...
in excel that enables me to jump from one text-box to anoter by using the
Tab-button, but view of the worksheet does not follow the tab.
 
Back
Top