Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm - Setting focus to a CommandButton based on a Cell's contents
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based on a cell's contents | Excel Discussion (Misc queries) | |||
Take Focus Off of CommandButton When Exiting UserForm | Excel Programming | |||
How do I make a cell's contents equal to another cell's contents with macro program? | Excel Programming | |||
Can I select a range based on the cell's contents? | Excel Programming | |||
CommandButton - Userform | Excel Discussion (Misc queries) |