Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2003
I have a button from the Forms toolbar named "Register". The button is on the sheet - not on a form. I would like to set the focus to this button in the following code Code Sub Worksheet_Change(ByVal Target As Range) If Range("A1").Value < "" Then Buttons("Register").SetFocus Else ........... other code.......... End if End Sub <<Code Obviously this does not work - it produces the following error:- "Run-Time error '438': Object doesn't support this property or method" Any help appreciated Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Set Focus a row - Option Button Click | Excel Programming | |||
Push Button in Outlook to Change Focus to Outlook Contact List | Excel Programming | |||
Option Button/Focus Problem on Worksheet | Excel Programming | |||
Set focus on command button | Excel Programming | |||
button focus | Excel Programming |