WOrksheet Change Event

[Luis939]

When using the Worksheet change event, Is there anyway that you can limit the event to absolute or relative ranges instead of the whole sheet? For example, if certain data is entered in column A, then it is checked for certain formatting..but the data in Column B is checked for another criteria. Thanks

 

[PHV]

Take a look at the Application.Intersect method

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Luis939]

Ok, i think i could use that...but i saw a spreadsheet where it seemed that different ranges (not necessarily a whole column) had its own criteria for entering data....if certain data did not have correct data when entered in one range, a msgbox would be displayed and the same for a different range that had different criteria...i wonder if that person specified a certain range e.g. from A10 to A100 where certain code would execute on a certain event, and also if a row was inserted/deleted in a range, then the code would cover that new change...is that possible?
thanks

 

[Loomah]

Hi Luis
Something else you could look at if you're trying to control user input is Data Validation. To a certain degree it would enable what you are asking in your second post.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[Luis939]

ok ill look into it...i want to try something similar...i just dont know how the author structured his code, you know? and its password protected...so ill look into it and appreciate all suggestions, thanks!