validation code

[knutmoen]

Hi!

I have a list of chapters in excel. one column is used to write "x" on the rows that represent the chapters i want to include in a document. I want to be able to do some choices in excel. Like, all the chapters are optional, but some chapters can't be included in the document at the same time. So i want some validation-code that results in a error-message whenever a user mark two rows which can't be included at the same time.

i hope you understand what i mean:p


thanks

[nattasiray]

Dear krutmoen

It's good that post some sample of data, your question and your need on website. It will help use to help you correctly.

[mudraker]

what you want can be done with a worksheet change macro.

With out specific details I can only give general answers


'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location

'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed

Please Login or Register  to view this content.

To test macro enter X in B3 & B4

[knutmoen]

your code work... but i have problems with making it work for like 5 cells. so what should i do if i want to disallow the user to choose more than 1 cell out of 5?


thanks again