Help with code

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 

0
anonymous (74722)
5/4/2004 7:06:03 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
688 Views

Similar Articles

[PageSpeed] 37

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" <anonymous@discussions.microsoft.com> wrote in message
news:90A107B2-B1D1-4270-B967-C693471B0024@microsoft.com...
> 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 !
>


0
croberts (1377)
5/31/2004 8:21:27 PM
Reply:

Similar Artilces:

Help External Utility for creating recurring events
Hoping that someone may have a suggestion for this: Are there any external (to Outlook) utilities for creating recurring events that could be imported into Outlook as individual events? I'm having all sorts of grief with OL 2007 and recurring events. (like: if I want to add text to a single occurrence, I get a waning that the time has changed (and do I want to send updates) - when it hasn't - and I don't have the option of changing an event without notifying others invited to the event). Thanks for any advice ...

Help With Powershell Script.
Hi Folks, Still a novice here so bear with me if this was discussed before. I wrote a small script to kill and restart a custom service that runs on our servers in our network, only to discover, that some of the servers have a 64bit version of the service hat also has a different name. I would like to run one script, detects what service is running on those servers and kills is using pskill from sysinterals (now owned by Microsoft) and then start it. The service name is for now, myservice and the 64bit version name is myservice64 I originally had the script as follows. ...

Newbi needs a very small help, thank you very much.
Newbi needs a very small help, thank you very much. Hello everyone and thank you very much for your time. I Have a small db for invoicing and on my form (with a subform) there is a CANCEL button which will just cancel what had been selected or entered in the form ... here is the code behind the cancel button... Private Sub Cancel_Click() Me![BillsFormSub].Form.Refresh DoCmd.SetWarnings False DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 DoCmd.SetWarnings True Exit_Cancel_Click: Exit Sub End Sub This was working ...

need help on how to add comment to xml schema with C#
how do you add a comment line/section to an xml schema xsd file? like this <!-- =============================================================== --> <!-- =================== My comment line ======================== --> <!-- =============================================================== --> I like to add a section before each element. Currently, I am creating a large xsd file with many elements. Thanks comic_rage@yahoo.com wrote: > how do you add a comment line/section to an xml schema xsd file? > > like this > > <!-- ==========================...

Help, Pls
C Drive crashed, installed O2002; have a months old .wab address backup, but O2002 won't import or allow additional address book. Is there any way to recover the addys in the backup file into O2002? TIA - wlc ...

Microsoft visualc ++ 5.0
It is stopping all development. I know I can upgrade to version 6 but version 5.0 is fine for me. It really is not good enough for Microsoft to say they are no longer supporting 5.0 and then to kill it off with xp sp2. I am going to have to uninstall sp2 to carry on. Anybody know of a fix for this ? Regards "Terry" <terry@tbean.freeserve.co.uk> wrote in message news:d3dorb$q18$1@news8.svr.pol.co.uk... > It is stopping all development. > > I know I can upgrade to version 6 but version 5.0 is fine for me. > > It really is not good enough for Microsoft ...

Russ Valentine MVP: Can you help with my Microsoft Outlook Contacts folder problem?
Hi Russ, In searching for some help with my problem, I noticed you seemed to be the resident expert on solving problems involving Microsoft Outlook. I am running Windows XP SP2 and using Outlook 2002 V10 Build 4219. I deleted my primary contacts folder (see below for the longer story).* I then generated a second contacts folder and named it "Friends". When I go to the Contacts folder (under my personal folder list) I have series of blank gray bars and the title is "Contacts (blank)-(blank)". If I click on any of these blank gray bars I open up the window showing the spe...

Help, importing most current data from web query
I have the following code but how do i edit this macro that will allo me to do a web query on the most recent data. For example, I just nee the high, low, close of stock X as of Feb 27th. So on the web query, only need the following data in my sheet: Date Open High LowClose Volume Adj. Close* Feb-26-04 49.7 50.8249.2950.5 3,342,100 50.5 Thanks in advance and any help is appreciated. Sub Stock1() Dim CoSym As String CoSym = Worksheets("Main").Range("C3").Value With Sheets("Stock 1").QueryTables(1) .Connection = _ "URL;http://table.finance.yahoo.com/k?s=...

Great Plains 6 Country Codes
I am trying to extract country codes from a Great Plains 6 SQL backup with: select SLSTERCD from RM20101 This gives me a set of good results in 7.5 and they aer nearly ISO compliant so I can work out where they relate to. However, in version 6 the results are not even close. They come back as: " " "1" "2" "RDCO" I can;t find a lookup table anywhere which can decipher these results. Is anyone able to point me in the right direction? SLSTERCD is the sales territory ID - these are created by users and can be anything you want, they don't have to...

Help!!! Autofill rows
I have a report that gets updated monthly. Some info comes in the report, the rest I have to put in. I take my original report and copy it to two worksheets within the workbook (Original, Changes, Inventory). On one sheet (Inventory), I can vlookup information from the previous month's report, and it fills it in. Vlookup doesn't work on the other sheet (Changes), even though there are no formatting differences, using same report from previous month. Col a = company number col's b-h need to be filled in identically to all other months based on the company number (column ...

leaderboard style chart??? help!
This is probably an easy question to most. I am hosting a tournament an need to be able to enter all scores and then have it give me 1st, 2n 3rd etc. Can anyone help? I have fill out all the names, can get th sum function to give total but not in order of name and score. Thank -- evanmc ----------------------------------------------------------------------- evanmc7's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2740 View this thread: http://www.excelforum.com/showthread.php?threadid=46919 Can you sort your data by the score column? evanmc7 wrote: > > ...

I'm beginner in powershell.....Neeed your help.
Hello, I wrote my first script in powershell. This script lists all users in a group on a server. It seems easy for the specialist but I think my code is not optimized. Could you help me to improve my code and I need your advice to avoid the gaps. Thanks in adanace for your help. Commande line PS > EnumerateGroupAndUsersV2.ps1 desktop15931 106013 Script fileName =3D EnumerateGroupAndUsersV2.ps1 function get-groupmember([string]$group, [string]$server=3D".", [string] $user ){ if (! $group) { throw "Vous devez pr=E9ciser le nom du groupe =E0 par...

Access Page Help!!!
Hi, I found a few messages about DAP's in this group, but none with info that will help me. I've spent a considerable amount of time searching, but can't seem to find answer and I'm hoping someone here can help. I have a form in a simple database that holds a literature collection with links to pdf files on server. Some users do not have database and I'm trying to set up the data access page for them to use. There will be no user entry, just searches and linking to pdf files. I have a form that I set up with the following code for a command button for each record...

Publisher 2003 now mirrors all documents on the printer. help!
Publisher 2003 has been working properly for several months and now eveything I print is mirrored. All other programs print correctly. Compaq SR1923WM, Windows XP SP2, HP Officejet Pro L7500 series Printer on USB02. Yes, Mirroring is set to Off in Properties. Printing a document at home is normal, so it's not the document and I can set mirroring on & print mirrored if desired. No, I have not reloaded Publisher. Oh by the way, that computer is not Internet connected. There is no Phone line in the 100+ year Old Museum Bldg and no funds for a wireless connection. I would greatly...

Bar coding solution
Can anyone recommend a good bar coding solution that will integrate with Great Plains? The solution should be able to handle: Receival of inventory Stock counts and other inventory management tasks Sale of inventory Thanks Look at Maximum Data's solution. We have it at several customers and are very happy with the product and their support. -- Richard L. Whaley Author / Consultant / MVP Documentation for Software Users For help learning and better using Dynamics GP,... check out our books at http://www.AccoladePublications.com "Jamrock" wrote: > Can anyone recom...

help #4
please help me get my money back just download the brochure http://www.ArmchairTycoon.com/bobcam/business dont have to read it, just delete it thanks ...

Canadian Zip Code Lookup
I have 250+canadian Contacts in Outlook, and need to find thier zip codes. Is there any temple or download to automatically find the zip code, or do I have to do it manually? Most of automatic stuff returns the location if you provide the zip code. Forlift Guy 31105 wrote: > I have 250+canadian Contacts in Outlook, and need to find thier zip codes. Is > there any temple or download to automatically find the zip code, or do I have > to do it manually? http://www.postalcodescanada.ca/ -- Peter Please Reply to Newsgroup for the benefit of others Requests for ...

Need help with QFX import
The only format that my 401k provider offers for statement download is QFX (that is Q as in quicken, not O as in Oscar). Is there anyway to import this format into Microsoft Money 2004 Premium? The 'convert quicken file' and 'import' menu options do not seem to work. The process of manually entering transaction takes forever. Can anyone help me? Thanks.. Dwayne In microsoft.public.money, John Smith wrote: >The only format that my 401k provider offers for statement download is QFX >(that is Q as in quicken, not O as in Oscar). Is there anyway to import &g...

Index Match Help
Data is dumped into Sheet1 and on Sheet2 I need a formula to pull out certain pieces of information. Here is what the data looks like: D.......P..R S 10 B R 3 10 B F 5 10 L R 10 10 L D 9 11 B R 20 11 B F 6 11 S R 20 I want to extract numbers from column S based on certain values in columns D, P and R. So, in order to give me the result of 5 from column S, here is what I'm using: =INDEX(S2:S41,MATCH(1,(D2:D41="10")*(R2:R41="F")*(P2:P41="B"),0)) I do Ctrl-Shift-Enter...

Query on a text file..help needed
I am trying to query a large text file and I'm beginning to wonder if it is just impossible to do. I used the excel query wizard but because I am working with a fixed length file I am not coming up with the columns I need. The wizard picks up each row as a solid block of information. Is there a way to pick out certain information from the text file into the query? so if my text line reads: 0110172006johndoe234street excel could pick out 01 10/17/2006 John Doe 234 street I know someone ran a query on my file and put it into the most beautiful excel spread sheet but it just isn't ...

creating dialog in ext dll from a VB app
I have a VB app that calls into a C++ COM dll. And in the C++ COM call I am trying to show a very simple (so far) dialog. Code as follows... int ret = DialogBox(GetModuleHandle(NULL), MAKEINTRESOURCE(IDD_DIALOG1), NULL, AboutDlgProc); The ret is -1 and GetLastError returns 1813[The specified resource type cannot be found in the image file] From looking at earlier posts is this related to the HINSTANCE (return from GetModuleHandle) being incorrect? Am I incorrectlly getting the HINSTANCE of the VB app, causing the failure to find the dialog resource defined in the C++ dll? thanks for a...

Need help : Open a csv file with semicolon separation
Hello everybody, I need to open a csv file with semicolon separation but the separation used is always the comma. I tried this differents methods : - Workbooks.OpenText Filename:="D:\Excel\data\file.csv", Semicolon:=True, Comma:=False - Workbooks.open Filename:="D:\Excel\data\file.csv", Format:=4 - Workbooks.open Filename:="D:\Excel\data\file.csv", Delimiter:=";" - Workbooks.open Filename:="D:\Excel\data\file.csv", Delimiter:=";" , Format:=4 If I rename the file as a text file, it works !!! If anyone has an idea, i want to...

NEED HELP:Soap error: operation requested in the Soap message with soapAction isn't defined in the WSDL file.
Hi all, I need some help. We have an application which is using SOAP to relay messages between two applications. We are having a problem, which started to only occur intermittently, but now happens all of the time. When communicating between the apps, we receive this message... Soap error: The operation requested in the Soap message with soapAction <http://tempuri.org/FormAPI/action/COutlookForm.isCateringAvailable> isn't defined in the WSDL file. This may be because it is in the wrong namespace or has incorrect case. The SOAP sender application is a VB6 COM dll hosted in a...

help with formula #25
I was going to have form submitted to me from a site. The data comes in the form of headers representing fields and the answers as number. So if it was a yes or no answer, the Yes is represented by a 1 and the no is a 2. Is there a formula that would change the number to a word. Thank you in advance. Hi It depends whether you want to replace your Yes and No with a number, or have a separate value column. For the first, you could use Find/Replace. For the second, in blank column alongside the data you could use something like this: =IF(A1="Yes",1,2) Hope this helps. Andy. &q...

excel formula help #5
hi all, i have two questions (1) ineed help on a formula to count names in a filtered list. (2) is it there a way to use ron's easyfilter when the page is protected. any help will be appreciated. thx wynb -- wynb 1) =SUBTOTAL(3,B2:B20) gives the number of items in a filtered list. 2) I will leave that to Ron. -- HTH RP (remove nothere from the email address if mailing direct) "WYN" <WYN@discussions.microsoft.com> wrote in message news:3AC44CE9-547F-4584-9116-4A3E2D0F18CC@microsoft.com... > hi all, i have two questions (1) ineed help on a formula to count n...