Create a help file for VB functions

S

Serkan

How do I make help files for the VB functions I have
written. Small explanations when using formula insert
would also do.

Many thanks in advance.
 
B

Bob Phillips

Serkan,

Check out this previous post on the topic.

http://tinyurl.com/352zx


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
E

erin

Hi,
Simplest way is with cell comments, which appear when
user moves mouse over cell

Application.DisplayCommentIndicator =
xlCommentIndicatorOnly

or you could create a Text Box (named HelpText below)
from the Drawing toolbar, then add a button that'll
toggle the visible property

Sub ToggleHelp()
ActiveSheet.TextBoxes("HelpText"). Visible = _
Not ActiveSheet.TextBoxes("HelpText").Visible
End Sub
 
Top