New Balloon - VBA

[JohnM]

New to this

I have followed the instruction to set up an help balloon, copied and pasted
the example into my module box but it does not work.
I do not really know where to start. I go into VBA and then Help am I
supposed to do something else

Thanks

john

 

[bigwheel]

So, what have you got in your module box?

 

[JohnM]

I just copy paste this from the help box

With Assistant.NewBalloon
.Heading = "Regional Sales Data"
.Text = "Select one or more regions"
For i = 1 To 3
.CheckBoxes(i).Text = "Region " & i
Next
.Show
End With

 

[bigwheel]

Do you have the Office Assistant visible?

I just copy paste this from the help box

With Assistant.NewBalloon
.Heading = "Regional Sales Data"
.Text = "Select one or more regions"
For i = 1 To 3
.CheckBoxes(i).Text = "Region " & i
Next
.Show
End With