where expertise comes together - since 1996 -

The Largest Open Access Portal of Nondestructive Testing (NDT)

Conference Proceedings, Articles, News, Exhibition, Forum, Network and more

where expertise comes together
- since 1996 -

267 views
Technical Discussions
Jairo Humberto Guzman
Jairo Humberto Guzman
05:55 Jul-27-1998
Re: Coloring cells for MS excel thickness survey report

I send a macro example to color cells in excel
sorry These example is in spannish, but you can change the colors and value range
good luck


' Macro1 Macro
' Macro grabada 27/07/98 por Red Nacional de Datos
'
'
Proced Macro1()
Para Cada d En Rango(Rango("A1"), Rango("d1").Desviar.Fin(xlAbajo))
Número = d.Valor ' Inicializa variable.
Seleccionar Caso Número ' Evalúa Número.
Caso 1 Al 2
d.Fuente.ÍndiceColor = 5
Caso 2 Al 4
d.Fuente.ÍndiceColor = 1
Caso 5 Al 6
d.Fuente.ÍndiceColor = 2
Caso 7 Al 8
d.Fuente.ÍndiceColor = 3
Caso 9 Al 10
d.Fuente.ÍndiceColor = 4
Caso SiOtro
d.Fuente.ÍndiceColor = 6
Fin Seleccionar
Siguiente
Fin Proced



    
 
 Reply 
 

Product Spotlight

Navic - Steerable Modular Automated Scanner

The Navic is a modular, motorized, steerable scanner designed to carry multiple attachments used
...
in various scanning and inspection applications. The Navic is capable of weld scanning (girth welds and long seam welds), automated corrosion mapping, and tank scanning.
>

HARDNESS TESTER TKM-459CE combi

TKM-459CE combi applies 2 methods of hardness control: UCI and Leeb. It provides high-accuracy tes
...
ting of metals and alloys as well as items of different sizes and configurations, their hardened layers and galvanic coatings. Device represents results in HB, HRC, HV and others. Shock-, dust- and water-proof housing with intuitive software make this gauge easy to use in all working conditions.
>

YXLON Cougar EVO

Scalable small footprint X-ray inspection systems for assembly and laboratory applications. The
...
YXLON Cougar EVO series was designed to provide the "best-in- class" inspection solutions for SMT, semiconductor, and laboratory assembly applications, while maintaining a small system footprint for maximum convenience. With optimized software and hardware, these systems produce higher quality and more consistent results than other electronics inspection systems currently on the market.
>

NEW - TD Focus-ScanRX

The NEW Next Generation Advanced UT platform, TD Focus ScanRX - Also available as a card stack solut
...
ion. Key Improvements 1. Data acquisition is significantly faster than current design 2. Better aesthetic – closely aligns with HandyScan RX 3. Improved IP rating (Target IP66) 4. Ruggedized housing 5. Connectors are protected from impact and ingress 6. Integrated stand and separate retractable handle easy to keep clean) 7. Touchscreen with ruggedized display glass 8. 3-Axis encoder input
>

Share...
We use technical and analytics cookies to ensure that we will give you the best experience of our website - More Info
Accept
top
this is debug window