my problem at the moment is i dont know how to add a menu to a custom
menu bar. I can see individual controls - but don't know how to add a
new menu heading, e.g. file, which i can drop other commands into.
Ok, when you are in customize mode, for each new "dropdown" you want, you
need to add a new menu.
So, choose the "commands" tab (when in customize mode).
Now, in the "categories" list, (the left side list), scroll all the way down
to "new menu"
click on "new menu". Now, on the right side, you get "new menu".
It is this "new menu" that you drag to your menu bar.
Now, to start adding commands to this, you scroll all the way back to the
top on the left side, and highlight "file"
Now, on the right side, you should see "custom", you can drag a "custom" to
the new menu you just made.
If you are moving existing button(s) from the form to remove clutter, then
you simply need to make the function in the form PUBLIC (
Public Function MyDelete()
Now, in the custom menu, right click, properties, and in the "on action",
simply put the name of the function you want
=MyDelete()
This approach allows you to run, and have custom code in the form....