I wrote a couple of macro functions which works well in the spreadsheet. However when I insert a formula into a cell, I would like to have a tooltip shown similar to those of the built-in function. Is this possible? If yes, how can I achieve this?
Unless I overlooked something that is not possible with simple Basic macro functions. It is possible with function Add-In extensions that can be written in Python, C++ and Java. If you want to dive into that (warning, a deep apnoea dive) see (taken from my scripting bookmarks):