User Form - adding a help file

[mortgageman]

Is there a general way (or any way) to add a help file to a user form?

Gene, "The Mortgage Man", Klein

 

[Tazguy37]

How about adding a ToolTip for each control? Would that do it?

 

[Fat Cat]

You could pop up another UserForm as the help screen and put the contents of the help file into a textbox on that form.

Make the Textbox multiline, wordwrap

Private Sub CommandButton1_Click()
Dim myText As Variant
Close #1
Open "c:\HelpFile.txt" For Input As #1
While Not EOF(1)
    Input #1, newText
    myText = myText & newText & vbCr
Wend
Close #1
TextBox1.Text = myText
End Sub

 

[mortgageman]

How about adding a ToolTip for each control? Would that do it?

It sounds good. What is it?

Gene, "The Mortgage Man", Klein

 

[mortgageman]

You could pop up another UserForm as the help screen and put the contents of the help file into a textbox on that form.

Make the Textbox multiline, wordwrap


code:

Private Sub CommandButton1_Click()
Dim myText As Variant
Close #1
Open "c:\HelpFile.txt" For Input As #1
While Not EOF(1)
Input #1, newText
myText = myText & newText & vbCr
Wend
Close #1
TextBox1.Text = myText
End Sub

The Line: Open "c:\HelpFile.txt" For Input As #1
(which I don't pretend to understand completely) suggests that the help file resides "outside" of excel and somewhere else on the computer. Does this make distribution more difficult?

Gene, "The Mortgage Man", Klein

 

[rs2k]

You could also put the help file info on a label (that way the help file will always be with Excel) and stick the label onto a userform which is triggered by a "Help" command button.

Colin.

 

[Tazguy37]

How about adding a ToolTip for each control? Would that do it?

It sounds good. What is it?

Gene, "The Mortgage Man", Klein

If you open the VBA Help, enter tooltip, and choose "What is a ToolTip? (Forms)" from the topics. Read all about it. Very neat, easy feature to implement. Not really a helpfile, but, as the name suggests, just tips on what to do ("Enter last name, then first name separated by a comma." Stuff like that.)

Hope that helps!

 

[mortgageman]

If you open the VBA Help, enter tooltip, and choose "What is a ToolTip? (Forms)" from the topics. Read all about it. Very neat, easy feature to implement. Not really a helpfile, but, as the name suggests, just tips on what to do ("Enter last name, then first name separated by a comma." Stuff like that.)

I read it all. I was able to figure out how to add a tool tip to my option buttons - (type it in the controltiptext in the properties section). But what if I want to change it during the userform operation? The help says I can do it, but it doesn't say how.

Gene, "The Mortgage Man", Klein