p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   Create text pop-up in VBA function (http://p2p.wrox.com/showthread.php?t=7092)

jimmy_chu December 10th, 2003 12:15 PM

Create text pop-up in VBA function
Hi all,

I have written a custom VBA function and would like to use it in Excel. But for my users sake, I would like to have the feature as other excel built-in functions have - when we type in "=func(" then a yellow text pop-up shown to notify user what parameter is to be entered.

I have done some research about this and know this is actually quite a big task. I have made the .chm file, associating Help Context ID with some text I want.

But my question is how to associate the VBA function to the help file in such a way that when "=myCustomFunc(" are typed in, the help string pop up?

Any help is greatly appreciated.

Jimmy Chu

All times are GMT -4. The time now is 07:04 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.