description text in vba object browser not saving

eviMogwai

New Member
Joined
Jul 4, 2011
Messages
26
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.

rv29a19g


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.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Image broken, took me too long to fix, edit-window ran out.
But here it is =)


My excel version is in swedish, but I hope you recognize the dialog box anyhow
Quick translation:
Swedish - English
Medlem - member
Beskrivning - description
Hjälp - help
hjälpavsnittsnr - help section number
klasser - classes
globala - global
Avbryt - cancel
 
Last edited:
Upvote 0
Noone ever had this problem?
I've seen it mentioned in forum posts about function help, tool-tip and such, but noone has commented on it.
 
Upvote 0

Forum statistics

Threads
1,224,518
Messages
6,179,261
Members
452,901
Latest member
LisaGo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top