When you run the addin you need to set the option for startup, or on demand. Then start up Excel. You will be able to step through you code at this point. I have found that I can't seem to get to the Menus, but can create toolbars and buttons all day long.
http://support.microsoft.com/default...EN-US%3B238228
This link is what I used to get started. You can translate almost all (I say that cause I haven't found one I couldn't but you never know) of VBA straight from Excel. Just export the files. In VB when you are referencing a excel function, it is easier to fully qualify the vars so VB doesn't get confused and use it's definition instead of Excel's.

btw You will not see the default form, I have no clue why cause you can run the code in the form but unless you say .show you will not see it.