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?
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?