I apologize in advance if this has already been answered, searching for "help text not saving" is quite useless (as it omits "help" and "not" for being too common)
So, I've been programming a bunch of functions in two modules and I'd like for some kind of tool-tip to be available for the user. I have gathered that in Excel 2007 it is impossible save for manipulating the core libraries and so I settled for useful descriptions in the function wizard.
So I do as I've succeeded once before, I access the VBA Object Browser, click to my project/module/function and right-click to get a dialog asking me to input description and press ok.
When I press ok, the dialog closes and... _nothing_ happens, it hasn't saved the description.
I have done this or something very like this sucessfully on two functions, but I am stumped as to why that worked.
So, I've been programming a bunch of functions in two modules and I'd like for some kind of tool-tip to be available for the user. I have gathered that in Excel 2007 it is impossible save for manipulating the core libraries and so I settled for useful descriptions in the function wizard.
So I do as I've succeeded once before, I access the VBA Object Browser, click to my project/module/function and right-click to get a dialog asking me to input description and press ok.
When I press ok, the dialog closes and... _nothing_ happens, it hasn't saved the description.
I have done this or something very like this sucessfully on two functions, but I am stumped as to why that worked.