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 -
309 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

Conformable wedge transducer

The conformability is obtained with a flexible membrane filled with water between the transducer and
...
the inspected component. The coupling between the membrane and the component requires a small quantity of water or couplant. The conformable wedge combines the acoustic performance of immersion technique with good coupling and low attenuation.
>

TraiNDE UT

TraiNDE UT is a virtual tool associated with a signal database which simulates real inspection con
...
ditions for numerous applications (Type A/V1 block, DAC block, welds and plates).
>

AIS229 - Multipurpose Real Time System

Latest standard & automatic real time system developed by Balteau. The AIS229 has been designed to
...
do series inspection in a wide variety of industry. Composed of a shielded cabinet, 5 axis manipulator, x-ray generator and tubehead from 160kV to 225kV, a fl at panel & much more, the AIS229 is most certainly one of the most multipurpose RTR system available on the market.
>

ISONIC 3510

Very Powerful Superior Performance Extremely Portable Smart Phased Array Ultrasonic Flaw Detector an
...
d Recorder with 2 Conventional UT and TOFD Channels uniquely combines PA, single- and multi-channel conventional UT, and TOFD modalities providing 100% raw data recording and imaging. Suitable for all kinds of every-day ultrasonic inspections
>

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