VB for Excell

[Evening]

I'd like to make a main menu in Excell like:

MENU
Row Column
B C D
1 Option-1
2 Option-2
3 Oprion-3
4 ----
5 -----

I'd like to iniciate some events with clicking on some field by mouse, or by pressing enter.
So If I click on the B1,(Option-1) it should happen something (Like open a new sheet, calculate something etc...) I can make the programming of what should happen after i clicked on the Option-1 (by recording the macro)
The only problem I dont know how to set-up in VB to iniciate the event.
Could someone show me how to do it?

 

[SkipVought]

Hi,

Since this is a VBA question, please post in VBA Visual Basic for Applications (Microsoft) forum707.

Skip,

_[red][/red]