UserForm - Setting focus to a CommandButton based on a Cell's contents

P

PCLIVE

I have another UserForm Question. I have a series of CommandButtons that
are named, starting at M1 through M76. When I show the UserForm, I know I
can set the focus to CommandButton "M11" by using the following.

UserForm3.M11.SetFocus

Is there a way I can set the focus in this same way except "11" would
actually be the contents of a cell which determines which command button the
focus should be set for?
Let's say A1 contains the number "11".

I know the code below doesn't work, but this is the idea.
UserForm3."M" & Range("A1").value.SetFocus

Can this be done?
Thanks,
Paul
 
P

PCLIVE

Well I thought I tried your suggestion, but I guess it what I tried was
slightly different. Anyway your suggestion works perfect.

Thanks,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top