Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SetFocus problem
Hello,
please does anyone know why this code gives run-time error - object doesn't suport this properity or method Private Sub Radio2_Click() Worksheets("start").TextBox3.Enabled = True Worksheets("start").TextBox3.BackColor = &HFFFFC0 Worksheets("start").TextBox3.SetFocus -THIS LINE CAUSES RUN-TIME ERROR End Sub thanks in adavance for any suggestions JH |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SetFocus problem
You have to use activate when it is located on a worksheet. The setfocus
method belongs to the control object and it is only available in a userform. -- Regards, Tom Ogilvy "JH" wrote in message ... Hello, please does anyone know why this code gives run-time error - object doesn't suport this properity or method Private Sub Radio2_Click() Worksheets("start").TextBox3.Enabled = True Worksheets("start").TextBox3.BackColor = &HFFFFC0 Worksheets("start").TextBox3.SetFocus -THIS LINE CAUSES RUN-TIME ERROR End Sub thanks in adavance for any suggestions JH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setfocus | Excel Programming | |||
Userform setfocus problem | Excel Programming | |||
SetFocus Problem | Excel Programming | |||
TextBox SetFocus Problem | Excel Programming | |||
SetFocus problem | Excel Programming |