how used openoffice.org basic macros

[azimah]

hi, i need ur help
first of all i want apologize for my broken english...
actually im new user of openoffice.
i want use openoffice.org basic macro...
what code should be............
if i want the selected cell i was select in cell calc change to word i want..

for example
in cell A1- the value is 0....so i want use run macro then it will change to "hardware"

for now i just used manually
like this
=IF(A6=0;"hardware";IF(A6=1;"Misc";IF(A6=2;"Network";IF(A6=3;"Oscc Product";IF(A6=4;"Policy";IF(A6=5;"R&D";IF(A6=6;"Security";IF(A6=7;"Software";IF(A6=8;"Training")))))))))

i hope u can help me