After spending a fair a bit of time searching around both on VBF and the net in general, I ran across this with respect to adding a dropdown menu bar to an Excel UserForm
notionally you can't. the forms object model doesn't support menus. You can do it in VB, but not VBA. There have been some kludge workarounds, but I wouldn't recommend it unless absolutely crucial to you
Is this pretty much the case?