Thread: Status of Focus
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Status of Focus

I think you have to find if the ActiveControl is the one you're interested
in.

Private Sub UserForm_Click()
Debug.Print ActiveControl.Name
End Sub


--
Jim
"Soniya" wrote in message
oups.com...
| Hello!,
|
| Is there a way to check the status of focus in a userform control?
|
| some thing like :
|
| if Textbox1.focus = true or if textbox1.setfocus = true ???
|
| Thanks
|