New Balloon - VBA
 

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
--
JohnM

New Balloon - VBA
 

So, what have you got in your module box?

"JohnM" wrote:

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
--
JohnM

New Balloon - VBA
 

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

--
JohnM


"bigwheel" wrote:

So, what have you got in your module box?

"JohnM" wrote:

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
--
JohnM

New Balloon - VBA
 

Do you have the Office Assistant visible?

"JohnM" wrote:

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

--
JohnM


"bigwheel" wrote:

So, what have you got in your module box?

"JohnM" wrote:

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
--
JohnM