Macro/VBA How to do? after selection shows the cell next to

[marek_maro]

After selecting the cells had to show the cell next to, but I did it traditionally wanted to made it using VBA/Macro.
Can anybody help me whit that ??
This may help
http://www.clo.cba.pl/klucze_1.xls

 

[Andrew Poulsom]

I haven't looked at you workbook but maybe you need eg:

Activecell.Offset(0, 1).Select

 

[marek_maro]

Yes, that is good....
but how to show the result in the second window ??

 

[Andrew Poulsom]

What second window?

 

[Andrew Poulsom]

Oh I see.

In F2 enter:

=INDEX('Baza danych'!$B$2:$B$230,F1)

In Design Mode set the TextBox's LinkedCell property to F2.

 

[marek_maro]

 

[Andrew Poulsom]

See Post #5.