General discussion
July 12, 2006 at 01:50 AM
gideon.wiedmann

Help with Class Modules

by gideon.wiedmann . Updated 20 years, 3 months ago

Hi
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

thanks

This discussion is locked

All Comments