| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm - Setting focus to a CommandButton based on a Cell's contents
Try using:
UserForm3.Controls("M" & Range("A1").Value).SetFocus -- Regards, Juan Pablo González "PCLIVE" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm - Setting focus to a CommandButton based on a Cell's contents
Well I thought I tried your suggestion, but I guess it what I tried was
slightly different. Anyway your suggestion works perfect. Thanks, Paul "Juan Pablo González" wrote in message ... Try using: UserForm3.Controls("M" & Range("A1").Value).SetFocus -- Regards, Juan Pablo González "PCLIVE" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
