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 -

316 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

OPBOX with standard software is able to do all types of inspections and measurements: flaw detection in welds and materials, scanning of objects, testing composite materials, forged and moulded pieces, many UT inspections, measurements of properties of ma

Typical applications: UT measurements with pulse technique, Measurement of thicknesses also at hig
...
h temperatures, Measurements of properties of materials, including fluids and gases We are delivering a standard version of the software (for any Microsoft Windows up to 10 x64 with Microsoft Hardware certification report Approved) and for special needs: SDK with ready to use examples for LabView, MATLAB x64, C++ wrapper for dll, Python and Linux., and also low-level description of how to control our devices directly from any USB tools
>

GEKKO - Portable Phased Array Testing with TFM in Real-Time

The portable phased array testing system GEKKO provides 64 parallel test channels. On creating testi
...
ng parameters the operator is assisted by the CIVA software. Due to its modular set-up the GEKKO instrument is suitable for operators of all skill levels.
>

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

VeeScan AirCraft Wheel Inspection

The VEESCAN offers maximum flexibility, has a proven mechanical design and records of breakdown-fr
...
ee operation of over 365 days. Appealing to companies in the Aerospace industry, the VEESCAN is ideal for all wheel-testing environments. With a wide selection of probes, the VeeScan allows your wheel testing facility the flexibility to select the most compatible configurations with their workload.
>

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