>>> Programming with symbols

Hi folks, I have a very easy doubt and I would like your advice. I plan to do something like this using MS Excel :

if the cell “A1” is equal to or greater than the number “12”, then the cell “C1” is equal to the cell “D1”

but “D1” is a cell that contains a symbol or a drawing character. For example : the letter “e” in format TIMES NEW ROMAN is the same as “epsilon” (greek letter) in format SYMBOL

Could anyone help? If it is necessary to use Visual Basic, where should I click and what steps should I make? Thanks a lot !

in c1 put: =if(a1>=12,d1,"")

then format the column c to be the font that you want the symbols to be in.

Ok, first you've got to create a CommandButton to execute the VBA-Code.
Unfortunately I only know the german version of MS Excel so you'll have to search for it on your own. It's probably a window called "tools".
After adding the Commandbutton open the VBA Editor, pressing ALT+F11
Now paste the following code

Please Login or Register  to view this content.

this code checks if Cell A1 has a value >= 12
in case it's true, it transfers the value of cell D1 to C1 and all values according to the font property such as font-family and size and color a.s.o.
if A1 is <12 or empty it does nothing

Good luck searching the tools-window

Simon

Great posts Moondark (Simon) and Tkaplan !

The kind of answers that trully help ! Thanks a lot for your time. Different ways of dealing with the problem. Just great.

Cheers,
Maleck