I'm Italian and I'm trying to learn English language as better as
possible in order to try to pass an FCE exam next 10th June.
For a better memory training I thought that:
I would do a lot of "repetitions".
I try to explain better (and I'm super super super rossy for my really
poor English (in fact, I'm studying it)).
Using an Excel spreadsheet like that previously prepared by me:

A B
1 | adesso | now |
2 | even if | anche se |
3 | instead | invece |
4 | indeed | infatti |
5 | brush up | rinfrescare |
6 | etc. | etc. |
7 | . | . |
8 | . | . |
9 | | |

the "software" or the "macro", random should give me a question taken
by, for example, what's found in Row 3-Coulmn A (instead) than wait for
my answer (invece) that's what is written in the same row but in Column
B.

On 21/01/2014 21:01, (.:.) wrote:
I'm Italian and I'm trying to learn English language as better as
possible in order to try to pass an FCE exam next 10th June.
For a better memory training I thought that:
I would do a lot of "repetitions".
I try to explain better (and I'm super super super rossy for my really
poor English (in fact, I'm studying it)).
Using an Excel spreadsheet like that previously prepared by me:

A B
1 | adesso | now |
2 | even if | anche se |
3 | instead | invece |
4 | indeed | infatti |
5 | brush up | rinfrescare |
6 | etc. | etc. |
7 | . | . |
8 | . | . |
9 | | |

the "software" or the "macro", random should give me a question taken
by, for example, what's found in Row 3-Coulmn A (instead) than wait for
my answer (invece) that's what is written in the same row but in Column B.
Considering the fact that as a programmer I'm "below zero", it's
complicate to realize something like that?
Does already exist something that should do what I need so I can use it
immediatly without spend my few time in programming and using it for
study English?
Thanks!

How about something simple and all in the spreadsheet?

Set
E2 =INT(RAND()*COUNTA(A:A)+1)
E3 =INDEX(A:A,$E$2,1)
F3 =INDEX(B:B,$E$2,1)
Conditional format G3 green if G3 = F3

Calculation mode to manual. Give it a quick test then hide column F.
Or set the text colour in F3 to white(then select to see right answer)

Pressing F9 will give you a new random test.

--
Regards,
Martin Brown

Martin Brown ha spiegato il 22/01/2014 :
On 21/01/2014 21:01, (.:.) wrote:
I'm Italian and I'm trying to learn English language as better as
possible in order to try to pass an FCE exam next 10th June.
For a better memory training I thought that:
I would do a lot of "repetitions".
I try to explain better (and I'm super super super rossy for my really
poor English (in fact, I'm studying it)).
Using an Excel spreadsheet like that previously prepared by me:

A B
1 | adesso | now |
2 | even if | anche se |
3 | instead | invece |
4 | indeed | infatti |
5 | brush up | rinfrescare |
6 | etc. | etc. |
7 | . | . |
8 | . | . |
9 | | |

the "software" or the "macro", random should give me a question taken
by, for example, what's found in Row 3-Coulmn A (instead) than wait for
my answer (invece) that's what is written in the same row but in Column B.
Considering the fact that as a programmer I'm "below zero", it's
complicate to realize something like that?
Does already exist something that should do what I need so I can use it
immediatly without spend my few time in programming and using it for
study English?
Thanks!

How about something simple and all in the spreadsheet?

Set
E2 =INT(RAND()*COUNTA(A:A)+1)
E3 =INDEX(A:A,$E$2,1)
F3 =INDEX(B:B,$E$2,1)
Conditional format G3 green if G3 = F3

Calculation mode to manual. Give it a quick test then hide column F.
Or set the text colour in F3 to white(then select to see right answer)

Pressing F9 will give you a new random test.

Thanks, many thanks.
I'll try it immediately!

Martin Brown ha usato la sua tastiera per scrivere :
How about something simple and all in the spreadsheet?

Set
E2 =INT(RAND()*COUNTA(A:A)+1)
E3 =INDEX(A:A,$E$2,1)
F3 =INDEX(B:B,$E$2,1)
Conditional format G3 green if G3 = F3

Calculation mode to manual. Give it a quick test then hide column F.
Or set the text colour in F3 to white(then select to see right answer)

Pressing F9 will give you a new random test.
Hi Martin, it's all "quite" OK.

First.
I've to translate all the function in italian (that's so boryng and
annoying) otherwise my Excel doesn't work (pehraps it's like all
Italian things, wonderful but don't work?).

Second.
The random generation is pretty OK and works fine.

Third.
The conditional format quite works. the green appear only for a too
little while and often I can't get it if my answer is correct or wrong.
I think that's happen because the conditional format work with the real
content of G3 and F3 cells.

This is that happen:
1) the routine show me in G3 the English word;
2) I write the Italian translation in F3;
3) I press Enter key;
4) the conditional format start to work and F3 cell turn in green; in
the same moment the routine are changing the English word in G3 and the
conditional format works again turning the colour in white. The result
is that for a too little while the F3 cell flash in green and often is
impossible to get it the real result.

If you have (and obviously if you want), would you mind give me some
suggest fo fix that?

Hi,

Am Thu, 23 Jan 2014 09:53:23 +0100 schrieb .:.:

This is that happen:
1) the routine show me in G3 the English word;
2) I write the Italian translation in F3;
3) I press Enter key;
4) the conditional format start to work and F3 cell turn in green; in
the same moment the routine are changing the English word in G3 and the
conditional format works again turning the colour in white. The result
is that for a too little while the F3 cell flash in green and often is
impossible to get it the real result.

like Martin wrote:
You have to set calculation mode to "Manual" and then for changing the
word in G3 press F9


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Claus Busch ha spiegato il 23/01/2014 :

like Martin wrote:
You have to set calculation mode to "Manual" and then for changing the
word in G3 press F9


Regards
Claus B.
Uh-Oh, I've completely missed this step!
I think because I was feeling that all was working fine!
I've just done it and... ALL WORKS FINE!
:))))))))))))))))))))))))))))))))))))))))))
Many many many thanks Martin and Claus!