ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform: Unable to setfocus from multipage (https://www.excelbanter.com/excel-programming/434541-re-userform-unable-setfocus-multipage.html)

SMS

Userform: Unable to setfocus from multipage
 
let me make that slightly clearer:

textbox1
multipage:
|--------------------------------|
| |
| textbox2
| |
|--------------------------------|

textbox2 can not setfocus on textbox1 ("unexpected call to method or
property access" error)

Interestingly, textbox1 code CAN set the focus on textbox2

Thank you!


On Oct 5, 1:05*pm, SMS wrote:
Hi all...

More userform setfocus drama... (this is seems to be a VERY buggy area
for excel)

I have event code from an object that appears on a multipage page. *In
that code, it attempts to set the focus on a textbox that lives
OUTSIDE the multipage.

This causes an "unexpected call to method or property access" error.

If I move that textbox out of the multipage and onto the userform,
then all works well.

I have tried calling it explicitly: "Userform1.textbox1.setfocus" * no
dice. *same error.

Thoughts? *workarounds?

thank you!




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com