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

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
commandbutton does not answer 0
Using a variable to select a CommandButton and setting the caption 4
UserForm CommandButton Caption 3
How to make scroll bar permanently visible, Word 365 0
Take Focus Off of CommandButton When Exiting UserForm 2
IS it possible to add Hyperlink to a commandbutton on a Userform 10
Naming UserForm CommandButtons using VBA 2

Top