Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Problem using tab in TextBoxes not in Userform


I'm actually working in Word, but there aren't as many programming
discussions. I discovered that the TextBoxes had to be "in line with text"
rather than "in front of text".

Now I've got another issue with my "tabs" not working when I link to the
document from my companies intranet. It opens Word in the Internet Explorer
Browser and somehow the "tab" code is disabled while all other macros in the
document continue to work as expected... any ideas.

The code I've ended up using is:
Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If KeyAscii = vbKeyTab Then
KeyAscii = 0
TextBox2.Select
End If
End Sub

I know how to change how the browser opens the document, but I cannot change
this setting on all users computers.

"Ken" wrote:

It worked fine in Word for me.
Ken

On Dec 4, 5:14 pm, Excel Curious
wrote:
Yes, I can see that it works... now if I want to do the same thing in Word
will it work the same? I tried it and it doesen't. Any idea on how to adjust
the code or settings for a Word document?

Thank you for your help



"Ken" wrote:
On Dec 3, 6:33 pm, Excel Curious
wrote:
How are your properties set up with regards to tabs for each text box?


autoload false
autotab false
enabled true
enterfiedlbehavior 0
enterkeybehavior false
imimode 0
tabkeybahavior false


I don't know what they all do, but, these are the ones that look most
likely to be relevant.


Good luck


Ken- Hide quoted text -


- Show quoted text -



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform and textboxes Paul Excel Programming 1 June 24th 08 11:21 AM
UserForm TextBoxes Rob Excel Discussion (Misc queries) 2 August 6th 05 03:07 AM
userform & textboxes beginner Excel Programming 3 July 27th 04 10:56 AM
userform textboxes again Jo[_6_] Excel Programming 4 October 21st 03 07:25 PM
userform textboxes Jo[_6_] Excel Programming 4 October 21st 03 07:15 PM


All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"