Discussion Locked

Help with Class Modules

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.