View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jennyc114 Jennyc114 is offline
external usenet poster
 
Posts: 1
Default VB code + Data Validation query


Hi there,

I am trying to assign data validation to a cell in a spreadsheet using
VB code, which as i understand is quite simple. I would also like to
create a 'warning' system, which returns a symbol to indicate whether
or not the validation has been met. For example, a red circle in the
adjacent cell if the validation has not been met, or a green circle if
it has. Is there a code which would meet these requirements? Or could
you advise me as to a better way of doing this?

Thanks,

Jenny


--
Jennyc114
------------------------------------------------------------------------
Jennyc114's Profile: http://www.excelforum.com/member.php...o&userid=24908
View this thread: http://www.excelforum.com/showthread...hreadid=384466