Excel 2010 VBA - error : Object variable or With Block variable not set

Question

I have an own class (ClassFoo) with a simple property (pName), and I could not set it, because I always get error ...

Class Modules - ClassFoo
---
Public pName as String

Public Property Let Name(Value as String)
   pName = Value
End Property
----
Somewhere else in the ModuleX
...
Dim Foo as ClassFoo
Foo.Name = "foo" <- throws error 
Foo.pName = "foo" <- throws error

or

With Foo
.pName = "foo" <- throws error 
End With

I changed the class 'Instancing' from 'Private' to 'PublicNotCreatable' (back and forth) But I still have the same error ...

Thanks for the replies in advance.

Cs

Alex K. · Accepted Answer · 2013-01-04 16:04:31Z

7

You need to create an instance & assign it to Foo so;

Dim Foo as ClassFoo
Set Foo = new ClassFoo

answered Jan 4, 2013 at 16:04

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bmo · Accepted Answer · 2013-01-04 16:04:47Z

2

You need to instantiate it I believe try

 Dim foo as new ClassFoo

answered Jan 4, 2013 at 16:04

Bmo

1,22211 silver badges36 bronze badges

Collectives™ on Stack Overflow

Excel 2010 VBA - error : Object variable or With Block variable not set

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related