Create a help file for VB functions

[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.

 

[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)

 

[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

 

[Guest]

Thnx Bob!

-----Original Message-----
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)




.