General discussion


Help with Class Modules

By gideon.wiedmann ·
Class modules have never been my strength and I hope this will help my understanding.

Say I want to create a criteria for the activecell. ie say the a.cell.value must be -ve & also that left(a.cell.offset(1,0),2) must equal "ha" (just simple text)

I want to create some thing like
If a.cell.HasMyCriteria = TRUe (FALSE) THEN.......(using this in a normal module)

where HasMyCriteria means fulfilling the 2 stipulations above. I want to use a class module to do this

Can anybody help


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums