Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default Help with userform problem: error message "obj doesn't support thisproperty or method"

I have some code that was working fine and now when I come to the
userform.show command I get the error message "Object doesn't support
this property or method.".

The only cause that I can come up with is I have been updating the
form from another computer and re-importing it into the workbook.
Possibly this caused some type of corruption? The userform does have
the name I reference in the code below also. Any other ideas on
getting it working again? It used to work just fine and no major
changes made.

Thanks, Chet

'SHOW THE DATA FORM
RunStatusSortSubtotal = True
FWRdataSortSubTtl.Show <<<<<<<<<<<=== Code crashing here!!
If Not RunStatusSortSubtotal Then GoTo TakeToEnd
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 523
Default Help with userform problem: error message "obj doesn't support th

Use F8 to step through the code - if there's some code in the userform
initialize event then an error there sometimes shows up at the frm1.Show
stage in debug.

Sam

"Chet" wrote:

I have some code that was working fine and now when I come to the
userform.show command I get the error message "Object doesn't support
this property or method.".

The only cause that I can come up with is I have been updating the
form from another computer and re-importing it into the workbook.
Possibly this caused some type of corruption? The userform does have
the name I reference in the code below also. Any other ideas on
getting it working again? It used to work just fine and no major
changes made.

Thanks, Chet

'SHOW THE DATA FORM
RunStatusSortSubtotal = True
FWRdataSortSubTtl.Show <<<<<<<<<<<=== Code crashing here!!
If Not RunStatusSortSubtotal Then GoTo TakeToEnd

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 82
Default Help with userform problem: error message "obj doesn't supportth

Goto ToolsOptions... in the VBE and on the General tab select Break
On all Errors.

Now when you get the error hit debug and you should be taken to the
code that's causing the error.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default Help with userform problem: error message "obj doesn't supportth

What you said worked.. there was an error in the code and now it
stopped at the error versus somewhere else! Thanks for the tip...
Chet
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 82
Default Help with userform problem: error message "obj doesn't supportth

Chet

No problem - remember to change the setting back.

Some code relies on using errors for some things, eg to see if a sheet
exists.

Personally I keep the setting to break on all errors, it's fun.:)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform problem with "obj doesn't support this property or method"error message. Chet Excel Programming 0 August 12th 09 05:26 PM
Error - Need assistance Please - Object doesn't support thisproperty... Bull Excel Programming 3 June 10th 08 11:57 PM
VBA error: "object doesn't support this property or method" Dave F Excel Discussion (Misc queries) 2 April 23rd 07 06:04 PM
Error Message "Select method of worksheet class failed" philc Excel Programming 5 May 4th 05 08:07 AM
"GoalSeek method of Range object failed" error message Fixit_Steve Excel Programming 0 January 13th 05 08:29 PM


All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"