View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derek Gadd[_2_] Derek Gadd[_2_] is offline
external usenet poster
 
Posts: 3
Default Set focus on command button

I have a command button on my worksheet and the code
"CommandButton1.SetFocus" gives the error message "Object doesn't
support this property or method". But the help shows SetFocus as one
of the methods for CommandButton. Why doesn't it work? I want to set
the focus so that the user can just press enter to click the command
button. Is this the correct approach?

TIA,
Derek