Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion

Locked

Help with Class Modules

By gideon.wiedmann ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums