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.

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)

"Serkan" wrote in message
...
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.

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)

"Serkan" wrote in
message
...
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.


.

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

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