View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bullman
 
Posts: n/a
Default Advanced cell validation help needed pls

Hello Biff,

Ahh, I see. So the VBA solution really is only good for one case
(cell) on the spreadsheet. Bugger. I really need it to be applied to
numerous cells/instances and cases on the same worksheet.

No problems, I will then use your crafty solution instead. :D

Thanks again

Bullman

Biff wrote:
Hi!

You can use a similar event procedure on OTHER sheets but you can't have
more than 1 per sheet.

OTOH, you can use similar conditional formatting techniques to your hearts
content!

Biff