Object not supporting property or method

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

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.
 
Stuart,

() to be used when declaring arrays, functions and subs. Not all variables,
just dynamic arrays.

Where else do you think you have seen it?
 
Yes, must have thought that variable was an array.

Regards and thanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error: Object doesnt support this property or method 2
MsgBox problem 3
Object doesn't support property or method 1
Deleting row from entry in listbox on a form error 6
Excel Providing user message when RED X clicked & properly closing application. 2
424 object required for object ReportItem 0
Compile Error:Variable not defined 4
Help with userform problem: error message> "obj doesn't support thisproperty or method" 4

Back
Top