View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Smith John Smith is offline
external usenet poster
 
Posts: 62
Default userform: object required

I got an error saying "object required" when the script attempted
to display a userform. What is VBA looking for?

The error only occurs when I programmatically insert the code via
VBA. If I copy and paste the code to worksheet's selectionchange
event procedure, it runs fine.

Private sub worksheet_selectionchange(.....)
aboutme.show 'aboutme is a userform
end sub