I've created a custom menu with submenus and can use macros from it, but I would like to use the selected words themselves.

For example, if my menu is named Foods and it lists Vegetables, Fruits, Grains and as sub menus has Peas, Lettuce and Squash under Vegetables.....how can i select Peas so that Vegetables is put into ActiveCell and Peas is put into ActiveCell.Offset (0,1)?

Thank you.

Feel free to email me [email protected]

steve