Strange Tab Key Behavior

I have a userform with about 20-30 textboxes.  When users use the ta
key to navigate, it will work, then all of a sudden just stop.  The ta
stays inside the textbox and tabs over spaces inside the userfor
textbox, but it does not jump to the next box.  This seems to b
intermittent, if the user restarts the form, it goes away, bu
eventually it sometimes returns to this weird behavior.  Has anyon
come across this, i am puzzled??

--
Message posted from http://www.ExcelForum.com

0
6/30/2004 5:56:27 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
560 Views

Similar Articles

[PageSpeed] 25

There's a tabkeybehavior property that sounds like is set to true for some and
false for others.

If you select the textbox (when you're designing the form), hit F4 to show its
properties, you can see that .tabkeybehavior.

Check out VBA's help for more info.

You could also use some code to set this property:

Option Explicit
Private Sub UserForm_Initialize()
    Dim ctrl As Control    
    For Each ctrl In Me.Controls
        If TypeOf ctrl Is MSForms.TextBox Then
            ctrl.TabKeyBehavior = False
        End If
    Next ctrl        
End Sub




"bg18461 <" wrote:
> 
> I have a userform with about 20-30 textboxes.  When users use the tab
> key to navigate, it will work, then all of a sudden just stop.  The tab
> stays inside the textbox and tabs over spaces inside the userform
> textbox, but it does not jump to the next box.  This seems to be
> intermittent, if the user restarts the form, it goes away, but
> eventually it sometimes returns to this weird behavior.  Has anyone
> come across this, i am puzzled???
> 
> ---
> Message posted from http://www.ExcelForum.com/

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
6/30/2004 11:48:16 PM
Reply:

Similar Artilces:

Strange behavior when setting Outlook 2003 with IMAP server
I setup out Outlook 2003 with an IMAP server and download the folder hierarchy. For some reason it's displaying two instances of INBOX although one is above the other in the hierarchy. I.E there is on folder called INBOX and another called INBOX.INBOX both contains the same emails. Can anyone explain why this is occurring? Mary <someone@mail.com> wrote: > I setup out Outlook 2003 with an IMAP server and download the folder > hierarchy. For some reason it's displaying two instances of INBOX > although one is above the other in the hierarchy. > > I.E t...

Strange traffic from Exchange Server
My XP personal firewall log shows some strange entries from an Exchange Server outside of my control. I have read http://www.petri.co.il/ports_used_by_exchange.htm but cannot find anything that can account for this traffic pattern. Basically, it seems to hit an increasing number of ports between 10,000 and 65,000, then start over again. Takes a few days to go through the whole range. Small sample below. Source port is an increasing range. Destination ports are - among others - 1108, 1518, 1091, 1082, 1088, 1067, 1191, 1306, etc. Mind you, this is from within a corporate firewall. Is this...

Print Setup, then Page Setup tab
This will probably seem trivial and obvious. I am trying to format a fairly large visio file. All drawings come out on four pages rather than one. I am trying to format the page. Most of this can be taken care of in the Page Setup tab, under Print Setup. My problem is that the Page Setup does not allow me to change the options, it's "frozen" can't click anything. Any idea what's causing that. It's a visio 2003 file saved for 2000. I'm working in 2000. Thanks, pepe ...

The Notes tab does doesn't "proforma" when you convert lead to cli
Why is this? I consider the notes and files attached to the notes essential data that would be required for quick viewing. To have to click back to the "Originating Lead" is a pain and the whole purpose of CRM is to make tracking customer data easier. -- Jay Edlin Microsoft Small Business Specialist ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in...

Quotes - Financial Results
Not sure if this is a place to report this, but the historical (average) P/E's on the Financial Results - Key Ratios page shows the P/E's with a mistaken shift in the decimal point. see http://moneycentral.msn.com/investor/invsub/results/compare.asp?Page=TenYearSummary&Symbol=bcs# where Barclay's Bank is showing average P/E's for the last 10 years of 158 to 228, which I think should be 15.8 to 22.8 instead. It seems to only be wrong for ADRs. You can "report" it here, but nobody here can do anything about it. Some might find it useful information, thou...

Strange Excel Problem (not printing): Excel 2004 & Leopard
Hi - I'm new here, and I'm happy to see a forum like this around - this is the first time I've stumbled on it. I recently installed Leopard, and I'm waiting until Office 2008 comes to our campus (i'm a staff member at UT). In the meantime, Excel is acting really strangely, including behavior like no longer allowing me to type directly in a cell until i double-click inside it. I haven't changed anything in the preferences or unchecked the box allowing one to edit in a cell directly. Previously I could click on a cell, start typing, and it would register my text - no ...

Strange......
Hi, I recently received a document from an external source which, upon opening, done something I have never seen happen before - it opens the same file twice, with one ending in "Issue: 1" and the other ending in "Issue: 2"; i.e. the file's name is "Schools", and when I click on the icon to open it, I get two files opening on my screen: "Schools Issue: 1"; and "Schools Issue: 2". Even more strange is that when I alter the formats or cell contents in one of the files, the other is automatically updated!! Normally I would just over...

automating the insertion of HTML tables (or tab delimited files)
Hi, I am completely new to Word programming, so I am not even sure if this is the way to solve my problem, but here goes: I have approximately 400-500 HTML tables in various HTML files (the data making up these tables also exists in tab delimited ASCII files). My goal is to insert the tables into a Word document. The problems I am facing are: 1.) How do I "loop" over each HTML file & "grab" the table & insert it into the appropriate place within the Word document? I can do this manually by going to "Insert" then "file" t...

Mapping the ESC key
I have searched through the entire project folder for the occurrence of IDCANCEL with Windows XPs search functionality, without result. However, ClazzWizard says that there is a control called IDCANCEL in my main dialog. I can't find any dialog item that is called IDCANCEL. This strange problem is probably the reason why a subdialog jumps up when I press the escape key. How do I map the escape key? Where can I find this mysterious definition of IDCANCEL? Thanks, Joachim It's a system ID. To override, check out CDialog::OnCancel (...). To completely override it, don't call the ba...

first tab to other tabs
Help Pls. i want to enter data in the first tab, without retyping them in individual tabs have the automatic sepeared in other tabs. exp. column a b c a b c a b c global 300 pcs 10 boxes global 300 pcs 10 boxes island 400 pcs 20 boxes island 400 pcs 20 boxes global 200 pcs 5 boxes island 300 pcs 10 boxes island 300 pcs 10 boxes global 200 pcs 5 boxes all vendors global island Thank You ...

Printing multi-page and multi-orientation excel tab to PDF
Could someone let me know if it is possible to print a multi-page tab in Excel to a PDF with multiple page orientations? Currently, I am setting the print area for each of the four pages and then printing each page seperatly to a PDF. Once complete I am combining each page into one PDF. I need all pages to print to one PDF with the proper size and orientation. My code is included below. Thank you in adavance for your help, Joe M Private Sub CommandButton2_Click() ans = MsgBox("Do you want to Export the Input page to PDF?", vbYesNo, "Confirmation"...

How to dynamically change the accelerator key of a menu item?
How to dynamically change the accelerator key of a menu item? Or at least to dynamically find the key associated with a given menu ID ? Thanks in advance -- Mav Rossi "Mav Rossi" <mavirc@WITHOUT.THIS.freemail.it> wrote in message news:oLX5b.16326$hE5.588129@news1.tin.it... > How to dynamically change the accelerator key of a menu item? Or at least to > dynamically find the key associated with a given menu ID ? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winui/WinUI/WindowsUserInterface/UserInput/KeyboardAccelerators/UsingKeyboardAccelerators.asp ...

change product key
anyway to change product key or installation ID other than re-install? hat to go through the update process all over again. ...

Money Plus Premium
Have Money Plus. Date on the box is 2007. I successfully downloaded my transactions from my bank through most of 2009. Then switched to quicken after the announcement of discontinution. Now I need to do my taxes for 2009 and simply need to open my money file and print out a report of transactions by category. I don't need to go online with my bank. I have now reinstalled Money Plus (after a harddrive crash) and when I try to open my Money file it asks me to enter a product key. Message: "The Key you entered is already expired. Please enter a new key." Is this r...

MIE 8 behaving strangely
When I do a google search and click on any of the links in the resuklts I'm not getting to the links, I'm getting other webpages. I downloaded Firefox and tried that and it did the same. Whats happening? You haven't told us anything about these "other pages" but most likely your computer is infected with adware. --- Leonard Grey Errare humanum est Trevor wrote: > When I do a google search and click on any of the links in the resuklts > I'm not getting to the links, I'm getting other webpages. I downloaded > Firefox and tried that and...

Strange problem with Taskbar
I've run into a strange problem only on my wife's computer. Whenever her computer is placed in "Standby" i.e. sleep mode, the little pop-up text boxes that identify the icons anywhere on the taskbar, pop-up BEHIND the taskbar instead of in front (or on top) of it. If I reboot, everything works fine for a while, but eventually the problem reappears. If I uncheck "Keep the taskbar on top..." the problem goes away, but then she has to minimize or shrink active programs to see the taskbar which is totally unacceptable. Any ideas on fixing this? How does it ...

custom primary key using multiple fields
I would like to create my own primary key using a concatenation of existing fields: eventnumber & date & time. How do I go about doing this? Any help is greatly appreciated. Thank you in advance. Why? Access is capable of using a primary key that's comprised of up to ten separate fields. Concatenating values into a single field is rarely a good idea. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "DGregg" <DGregg@discussions.microsoft.com> wrote in message news:BD804869-FD9D-473C-826B-48FB2B2BEC42@microsoft.com... >I...

Modify behavior of bi-directional line
I am creating an Active Directory site drawing showing site links. There a many of them and some links go through (visually) other sites. Is it possible to change the behavior of the line so that the site object is on top, i.e., the line passes behind the site object? you might try page setup, routing and layout to see if something works for you. al "Byron Boudreaux" <byronb@frontiernet.net> wrote in message news:%23QBHpRPmFHA.4000@TK2MSFTNGP12.phx.gbl... >I am creating an Active Directory site drawing showing site links. There a >many of them and some links...

Explorer 8 - Tabs
How do I configure so every new website opens in its own tab? Also, is there a way for my home page to be permanent (can't be closed)?-- Thanks ! Harvey Harvey wrote: > How do I configure so every new website opens in its own tab? Internet Options -> General tab -> Tabs -> Settings > Also, is there a way for my home page to be permanent (can't be closed)? If the tab cannot be closed, how are you going to ever exit IE8? If you have multiple tabs open, you won't be able to see your home page until you return to its tab; however, you can the...

page tabs
When working in a multiple page document, "page tabs" are displayed in the lower left of the screen. I have lost this display. Can anyone help? view, status bar -- Mary Sauer MS MVP http://office.microsoft.com/clipart/ http://www.mvps.org/msauer/getting_started.htm news://msnews.microsoft.com "karenbeale" <anonymous@discussions.microsoft.com> wrote in message news:13e9501c3f905$a4dbb240$a301280a@phx.gbl... > When working in a multiple page document, "page tabs" are > displayed in the lower left of the screen. I have lost > this display. Can any...

Dynamic tab controls
Hi, I hav created my dialog box dynamically and added the tab controls in the same way. Now the problem is where to handle the tab controls . I tried it in OnChildNotify(),but its not working. U can send me reply on <manish_4u5@yahoo.co.in> regards manish ...

naming worksheet tabs
i need to name a worksheet tab with a name that is more characters than allowed. Can you make the tab larger to accommodate a larger tab name? I know you can make the tab larger in properties/appearance/advanced; however, that does not allow me to type in more characters. -- Thanks, Sharon Thank you for your reply. -- Thanks, Sharon "Jacob Skaria" wrote: > Sorry, you cannot. > > Max length 31 > Exception characters [ ] * ? / \ > > -- > Jacob (MVP - Excel) > > > "SHARON" wrote: > > > i ne...

Moving Tabs Apart??
Instead of having all the Tabs go from left to right is it possible to move just one of them to the right-hand side??? Anyone know how?? I know you can change the size of the tabs I just want to try and move one away from the others. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200704/1 You can turn off the tabs from the control and create your own where ever you want. evilcowstare wrote: >Instead of having all the Tabs go from left to right is it possible to move >just one of them to the right-hand side??? > >Anyone know ...

Tab order 06-13-07
I am in version 3.0 of CRM. One of the user defined fields that I have is a pick list that opens a calendar drop down. When the user selects a date from the calendar, the tab order goes back to the first field. However, if the user writes the date in (without using the picklist) the tab order goes to the next feild as it should. Any thoughts on this? Thanks ...

Default Tab Stops change in Pub 2002
I just finished my first newsletter using Publisher. I was using a tab stop setting of .12 instead of .5. For some reason I haven't been able to pin down, the default would get reset to .5 with the result of text at the end of my text boxes getting pushed off the bottom. Resetting the tab stop to .12 would fix everything until the next time Publisher decided I really meant .5! Any clues about why this is happening would be much appreciated. Thanks, Steve It is a bug that has not been addressed in Pub 2002 or the soon to be released Pub 2003. The only way you can overcome this iss...