checkbox-property

[JohnLong]

I want to set the focus to a checkbox. But vba don't let me doing this. Therefore I want to add this property to the checkbox-property and set the focus to the checkbox. How can I manage this?

 

[AdrianScaife]

If my memory still serves me you can put a label just before the checkbox in the tab order and when the label receives the focus it gets bumped on to the Checkbox

 

[JohnLong]

I have tried that, but it doesn't work. When I try this, vba gives the message It can't set the focus on the object because this type doesn't accept "setfocus

 

[AdrianScaife]

Sorry ignore my last post I was thinking of something else!

Aer you using the VBA Controls Checkbox or the checkbox from Excel Forms?

 

[JohnLong]

I am using VBA-controls in Word

 

[AdrianScaife]

try

ThisDocument.CheckBox1.Select

It seems to work for me

 

[JohnLong]

I have tried it, but I'm sorry, it doesn't work. I got the message "The argument is not optional". Probably because you mentioned: thisdocument, in my application the checkbox is on a form.

 

[PHV]

Something like this ?
UserForm1.CheckBox1.SetFocus

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[JohnLong]

Hi,

Yes I tried this one also. Now I find out it doesn't work at all.
I am trying to get the focus to the checkbox by setting its tabindex. But then I get other problems. When I want to set the tabindex of the checkbox, there is no problem, because there are only three of them. But when I want to return to the commandbutton, I get problems because I don't know which button the last button was, and when I do know it, I have to write a lot of code!