View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default Checking for the border style of a range

Good morning all!

I recently wrote some event code that put a thick border around three cells
whenever they were clicked. This was to indicate the status of a job, whether
it was red, amber or green.
I now want to check which of the three cells has the outline, to transfer a
status of either red, amber or green to a record in a database.

I started with:

if activesheet.range("IssueRed").BorderAround Weight:=xlThick then

but this doesn't seem to be quite right.

Can anyone out there enlighten me as to the syntax I should be using?

Thanks in advance and have a nice weekend!

Pete