View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default Object not supporting property or method

Stuart,

Ditch the () that you keep appending to a statement.

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Stuart" wrote in message
...
With GetUserWkbk_PrintOptions()
.Show
gives the above error msg on '.Show'

If I amend it to:

GetUserWkbk_PrintOptions.Show
With GetUserWkbk_PrintOptions()
If .OKButton.Tag = "Selected" Then
MsgBox "OK Button was pressed"

then the form shows, but when returned to the
sbove code, 'If.OkButton...' returns the same
error.

Why is this happening in what I thought was
ok code, please?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003