View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SMS SMS is offline
external usenet poster
 
Posts: 15
Default 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!