How to setfocus textbox framecontrol

[dave8]

I created two (2) textboxes inside a frame. The frame I created is on a worksheet (not using USERFORM). What I want to do is have the cursor on the first textbox when I first open the worksheet. My code looks like this: Frame1.Controls("textbox1").setfocus . But, when the code executes, I get run-time error '2110', "Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus."

Is the syntax correct to SetFocus on Textbox1? And, is there anything in the textbox1 property I need to set??


David

 

[mikerickson]

What kind of text box is it? From the ActiveX toolbox or from the Drawing Menu?

 

[dave8]

Its from the ActiveX. Btw, how do I also access these properties? If I want the cursor to land on the second textbox2, for example, do I have to turn off the tabindex for textbox1 and activate textbox2?

For example:

frame1.controls("Textbox1").tabstop = false
frame1.controls("Textbox2").activate


Of course, the above example doesn't work, but you get the idea.

 

[mikerickson]

It appears that sheet controls don't support the .SetFocus method

 

[dave8]

Okay, do you have any suggestions?