Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
border colors and style | Excel Discussion (Misc queries) | |||
Change border style using VB | Excel Discussion (Misc queries) | |||
Create new border style? | Excel Discussion (Misc queries) | |||
Change default border style? | Excel Discussion (Misc queries) | |||
Border style of Excel forms | Excel Programming |