CommandButton focus

[Jaafar Tribak]

AFAIK, there isn't a Property similar to that of a UserForm ActiveControl but for controls embeeded on worksheets ?

I am asking because I have several embeeded ActiveX commandbuttons in a worksheet and would like to know which one has the focus.

Any thoughts?

 

[GlennUK]

Not as far as I know ( someone else may know ) ... but, ( you're gonna hate this ) you could code the GotFocus event for each one to update a flag as to which one was the last to get the focus. Just an idea ... I know that you know a lot about such things and may have already discarded that idea, but I thought I'd say so just in case.

 

[Jaafar Tribak]

Thanks Glenn for the reply.

That sounds good for what I am doing and ,to be honest, this simple solution never occured to me .

 

[GlennUK]

I'm so glad to have been of some help to you. I always enjoy your threads, and have a learnt a lot from you.