| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 27684 | 2002-11-28 10:05:00 | Excel VBA - Custom Menus | parry (27) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 102161 | 2002-11-28 10:05:00 | Hi I created a custom menu in Excel and assigned macros to them. I want to be able to add a tick next to a menu item when it is selected. The reason is I created my own function to turn metres into yards and yards into metres. I need a way of knowing which option was selected from the menu to determine what distance the existing cell values are in. I will also need to ensure that only one of these two menuitems is selected (ie not both checked). Any ideas how to do this? cheers Parry |
parry (27) | ||
| 102162 | 2002-11-29 00:05:00 | Can you clarify what constitutes a custom menu? Is it a Form, Button or linked to a cell etc |
Russell D (18) | ||
| 102163 | 2002-12-01 21:18:00 | Hi Russell, a custom menu is where you create your own menu such as the File-Edit-View menus etc. I got an answer for this question on Mr Excel so no worries. | parry (27) | ||
| 1 | |||||