LinkBack URL
About LinkBacks
Hi,
I would like to get help on my issue.
I can't setfocus on my textbox after initialize. I don't know why.. Please take a look at my excel file..
Here is my code ..
Inspection report.xlsm
Please Login or Register to view this content.
Thanks,
JP
Hi,
I would like to get help on my issue.
I can't setfocus on my textbox after initialize. I don't know why.. Please take a look at my excel file..
Here is my code ..
Inspection report.xlsmPlease Login or Register to view this content.
Thanks,
JP
You don't have a textbox qty1 in the userform1.
When in the userform module hit Ctrl & f,
find qty1
Which of the 11 userforms are you having the problem with?
If posting code please use code tags, see here.
Oops, just saw the reference to UserForm1.
Is it qty1 on the first page of the multi page you want focus on when the userform opens?
It's on userform1 initialize.
acbebc.jpg
Last edited by JPGraphX; 11-17-2014 at 06:03 PM.
I want to focus on qty1 when my userform opens. qty1 is on multipage 1 (not 0).
Any idea? (UP)
Have you tried just selecting the 2nd tab?
Please Login or Register to view this content.
What do you mean?
You have the TabIndex of the textbox you want to have focus set to 0.
That means that when the 2nd page of the multipage is activated that control will automatically have focus, you don't need any code to set focus on it.
Yes you are right. If I load my Userform1 and then click on multipage1 and after multipage2 my focus is at my textbox qty1. How to reproduce this ?
This doesn't work:
Please Login or Register to view this content.
Try the code I posted in post #8.
Oh really, no need to show!
SOLVED! Thanks !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks