Results 1 to 7 of 7

Thread: Weird Tab Key Results with VBA

  1. Aug 25th, 2005, 11:00 AM #1
    VB4fun
    VB4fun is offline

    Thread Starter
    Hyperactive Member VB4fun's Avatar
    Join Date
    May 2003
    Location
    too far from Fiji
    Posts
    342

    Weird Tab Key Results with VBA

    Every once in awhile, when I press the Tab Key on the form (with excel in the back), it creates a Tab within the textbox which has the focus. It does not move to the next cell.

    I have the Mulitiline and the TabKey Behavior BOTH set to False. It only seems to do it every so often, without a noticeable reason....

    Any ideas on how to fix this ?
    Talk does not cook rice.
    -Chinese Proverb
    Reply With Quote Reply With Quote
  2. Aug 25th, 2005, 11:40 AM #2
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Weird Tab Key Results with VBA

    What version of Excel are you using? Did you set the TabKey = False in the property window or via code?
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  3. Aug 25th, 2005, 01:51 PM #3
    VB4fun
    VB4fun is offline

    Thread Starter
    Hyperactive Member VB4fun's Avatar
    Join Date
    May 2003
    Location
    too far from Fiji
    Posts
    342

    Re: Weird Tab Key Results with VBA

    Using both Excel 2002 and Excel 2002 SP3.

    Setting via the property window.

    It is happening really sporatically.....can't duplicate the issue, when I try.
    Talk does not cook rice.
    -Chinese Proverb
    Reply With Quote Reply With Quote
  4. Aug 25th, 2005, 01:55 PM #4
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Weird Tab Key Results with VBA

    Have you done a Office Update lately?
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  6. Aug 25th, 2005, 02:51 PM #5
    VB4fun
    VB4fun is offline

    Thread Starter
    Hyperactive Member VB4fun's Avatar
    Join Date
    May 2003
    Location
    too far from Fiji
    Posts
    342

    Re: Weird Tab Key Results with VBA

    The development machine was updated last week.
    Been some time for the application machine (without the SP3)....

    I am getting the issue on both,
    but can't seem to reproduce the error now.....I know I am not going crazy...and I havent changed the properties...
    Talk does not cook rice.
    -Chinese Proverb
    Reply With Quote Reply With Quote
  7. Aug 25th, 2005, 03:16 PM #6
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Weird Tab Key Results with VBA

    Perhaps it copuld be a bug with Excel XP? Maybe a search on MS would shed some light on this.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  8. Aug 25th, 2005, 03:47 PM #7
    VB4fun
    VB4fun is offline

    Thread Starter
    Hyperactive Member VB4fun's Avatar
    Join Date
    May 2003
    Location
    too far from Fiji
    Posts
    342

    Re: Weird Tab Key Results with VBA

    Thanks for your help, I don't see anything on the MS site...
    I will wait for it to do it again, and analyze everything a little closer...

    Thanks again!
    Talk does not cook rice.
    -Chinese Proverb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width