Error: Object doesn't support this property

**Nancy123** · 10-26-2010, 06:02 AM

Hi Guys

I am getting the above error message in the following line which is bold and marked red.

Please Login or Register  to view this content.

**romperstomper** · 10-26-2010, 06:36 AM

How is blnAutomated declared/defined in the called form?

**Nancy123** · 10-27-2010, 05:01 AM

Its declared as below in called userform in 2nd workbook:

Public blnAutomated As Boolean

Thanks

**romperstomper** · 10-27-2010, 06:03 AM

That should work then. What does the GetForm function look like and what is the complete form code?

**Nancy123** · 10-27-2010, 06:05 AM

Hi Romper

Please find below the Getform code:

Please Login or Register  to view this content.

**romperstomper** · 10-27-2010, 11:57 AM

Can I see a copy of the second workbook (no data needed)?

**Nancy123** · 10-28-2010, 05:41 AM

Hi Romper

Please find attached a copy of the second workbook:

Thanks
Aman

**romperstomper** · 10-28-2010, 05:49 AM

Move the declaration of the variable to the top of the module, above all the procedures.

**Nancy123** · 10-28-2010, 06:22 AM

Thanks a lot Romper. It worked perfectly fine...

**romperstomper** · 10-28-2010, 06:58 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save