Calc Makro Programming - How to compare cell values

[Grabowski]

I'm trying to write a vocabular training tool with NeoOffice Calc. And there I want to use a makro to compare the content of two cells and depending on the result I want to set the color of the cell.

My very simple problem is now: How can I compare two cells using a makro?
The following program code doesn't work:
If B1 = B2 Then ...
or
If B1.Value = B2.Value Then ...
or
If Range(B1).Value = Range(B2).Value Then...
or ...

I don't know how to read the value of a cell. Unfortunately "Help" didn't help me.

[Samwise]

Unfortunately, there are few people here with in-depth knowledge of StarBasic and OpenOffice.org macros. You should get better answers there :

http://www.oooforum.org/

[Grabowski]

Thank you for your hint.
I didn't know that reading the value of a cell is a job for experts.
But fortunately I'm one of those experts now

[Samwise]

Yeah, well

It probably isn't such a big deal, but you have to learn the syntax somewhere, and if you don't know, it can take a long time to figure out; it's much easier to ask people who already know ...

[jgd]

Grabowski

You may check Andrew Pitonyak's document, which you can download here :

http://www.pitonyak.org/oo.php

Click PDF English Macro Document (Updated November 9, 2006)

It contains a chapter about Calc macros which can help you.

Jacqueline

[Jim]

Unless you want to do something other than change the cell's background color, then just use Format->Conditional formatting...

Let's say, for example, you want to indicate wrong answers by changing the cell background to red. Define a cell style with that background color, and name it "wrong answer". Then, click in the answer cell to select it, and choose Format->Conditional formatting... Set your parameters, choose the "wrong answer" style, and you're done. No macro needed.