"Text string you entered is too long" error when plot point clicked

[RowanB]

Hi Everyone,

I have written a routine that responds to scatter plot points being clicked using VBA.

The problem is that when I click a plot point, I get a "Text string you entered is too long" error message because the series collection is so big that it doesn't fit into the formula bar. I don't need it to appear in the formula bar. Is there anything I can do about this please? I'd be happy if it just didn't appear in the formula bar.

Many thanks in advance,

Rowan

[RowanB]

Does anyone have any ideas for this?

[Andy Pope]

without seeing any code or example it's hard to say, other than make the string shorter :p

[RowanB]

The code below is what I entered into a class module so that when a plot point on the chart is clicked, a user form opens. The problem is that the series string is too big for the formula bar. Is there a way I can just stop the series appearing in the formula bar?

Public WithEvents myChartClass As Chart

End SubPublic WithEvents myChartClass As Chart
Public WithEvents myChartClass2 As Chart



Private Sub myChartClass_Select(ByVal ElementID As Long, ByVal Arg1 As Long, ByVal Arg2 As Long)

Dim PS2 As Worksheet
Dim ColCount As Long

Chart2 = True
Chart1 = False

Set PS2 = Worksheets("Product Search 2")

If ElementID = xlSeries Then

If Arg2 > 0 Then

GlobalArg1 = Arg1
GlobalArg2 = Arg2
ColCount = 0

UserForm9.Show vbModless


End If

End If

End Sub