Thread: Show one of multiple comment boxes based on value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kurtech kurtech is offline
external usenet poster
  
Posts: 3
Default Show one of multiple comment boxes based on value
I have a worksheet that includes multiple comment boxes and have come across
something I need help with.

If the value in a1 15 then show a warning "value is greater than 15"
If the valude in a1 < 15 then show "acceptable value"

I'm a newbie at VB and Script Editor so details would be most appreciated!!
Reply With QuoteReply With Quote