A userform does not have a setfocus method. Why do you need to know if the focus is there?
what i want to be able to do is let the user to move down/up/left/right on the page without having to be touch the sheet at all or setting showmodal to false. As the userform is used to enter data into the sheet. The two other ways i thought of doing this was:
1) protect the sheets with a password and set showmodal to false and every time new information is entered using the userform, use vba to unlock and lock it.
2) when the userform is closed protect the sheets with a password and when the userform is active take password off
3) the way i wanted to do is being able to move on the sheet without having to lock and unlock it! i thought checking focus on userform i could unlock, and lock when focus isnt on userfom.