Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SetFocus using variable name
Sorry, I amended it in my test, should of course be
sField = Worksheets(5).Cells(nval, 1) Me.Controls(sField).SetFocus -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message news:... Taras, Try sField = Worksheets(2).Cells(1, 1) Me.Controls(sField).SetFocus -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Taras" wrote in message ... I would like to setfocus on a control in a user form using a variable name. ex: sField = worksheets(5).cells(nval,1) sField.SetFocus The value in worksheets(5).cells(nval,1) would be the name of a control on a user form Can this be done? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SetFocus on a different sheet in VBA | Excel Discussion (Misc queries) | |||
SetFocus using variable name | Excel Programming | |||
SetFocus Problems | Excel Programming | |||
SetFocus problem | Excel Programming | |||
TextBox.SetFocus | Excel Programming |