View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cheryl Cheryl is offline
external usenet poster
 
Posts: 144
Default setfocus on multipage tab form gives error message

I am trying to set focus on the first page or first text box on the first page once data has been loaded into the form from the worksheet. I am getting an error: when setting it to text box or first page of: "run-time error 2110 cant move focus to the control because it is disabled, invisible or of a type that does not accept focus". The tab and textbox are enabled and visible so maybe I am trying to put it in in the wrong place? Once the data is loaded onto the form.. It defaults to the last page/tab and I want it to show the first one.. How can I rectify this???