message keeps popping up

[Eisasuarez]

Hi All

I have a dropdown in a sheet that just updates my sheet as soon as the user changes a date

The problem I have that every time I change the dropdown box - I get this message "You're selecting something that doesn't exist yet...try again..."
but the actual figures and everything still updates

I want to get rid of this message but I cant

I tried disabling the alerts but still no luck

How can I get around this?

Thank You

 

[mumps]

Re: Arrrrhhhh - message keeps popping up

It sounds like you may have a line of code in your macro that generates the message.

 

[Eisasuarez]

Re: Arrrrhhhh - message keeps popping up

I don't I do buddy

this is my sheet code

Private Sub Worksheet_Calculate()
    If Intersect(Range("C2"), Range("C2")) Then
        Module1.WeeklyChartUpdate
    End If
End Sub

This is the code it calls in module 1

Public Sub WeeklyChartUpdate()
 
 Dim rngPaste As Range
 Dim StartCell As Long
 Dim EndCell As Long
 Dim ws As Worksheet
 Dim ws2 As Worksheet
 Dim ChartRange As Range
 
    Application.ScreenUpdating = False
    
    Set ws = Worksheets("Daily1")
    Set ws2 = Worksheets("Infographic")
 
        ws.Range("C195:E200").ClearContents
        
        StartCell = ws.Range("C194").Value
        EndCell = ws.Range("d194").Value
        
        Set rngPaste = ws.Range("C195")
        Set ChartRange = ws.Range(ws.Range("B195"), ws.Range("B195").Resize(6, EndCell + 1))
        
           ws.Cells(195, StartCell).Resize(6, EndCell).Copy
           rngPaste.PasteSpecial xlPasteValuesAndNumberFormats
           
           ws2.ChartObjects("WkChart").Chart.SetSourceData Source:=ChartRange
           
           If ws.Range("B194").Value = "SHRINKAGE" Then
               ws2.ChartObjects("WkChart").Chart.ChartType = xlColumnStacked
               ws2.ChartObjects("WkChart").Chart.SeriesCollection(1).Interior.Color = RGB(221, 235, 247)
               ws2.ChartObjects("WkChart").Chart.SeriesCollection(2).Interior.Color = RGB(252, 228, 214)
               ws2.ChartObjects("WkChart").Chart.SeriesCollection(3).Interior.Color = RGB(191, 194, 253)
           Else
               ws2.ChartObjects("WkChart").Chart.ChartType = xlColumnClustered
               ws2.ChartObjects("WkChart").Chart.SeriesCollection(1).Interior.Color = RGB(0, 176, 240)
               ws2.ChartObjects("WkChart").Chart.SeriesCollection(2).Interior.Color = RGB(226, 240, 217)
               
               ws2.ChartObjects("WkChart").Chart.ChartGroups(1).Overlap = -10
               ws2.ChartObjects("WkChart").Chart.ChartGroups(1).GapWidth = 100
               On Error Resume Next
                 ws2.ChartObjects("WkChart").Chart.SeriesCollection(3).Interior.Color = RGB(255, 230, 153)
               On Error GoTo 0
           End If
    Application.ScreenUpdating = True
  
End Sub

 

[mumps]

Re: Arrrrhhhh - message keeps popping up

I'm sorry but I can't see why that message is appearing. I did a quick search for that message and nothing comes up.

 

[Eisasuarez]

Re: Arrrrhhhh - message keeps popping up

I did a search also and could not find this message

hopefully 1 of the MVPs will know or someone

thank you

 

[njimack]

Re: Arrrrhhhh - message keeps popping up

Try using breakpoints to determine which line of code is causing it to fall over. I don't recognise that particular error message but I suspect the chart called "WkChart" has either been deleted or renamed.

 

[Eisasuarez]

Re: Arrrrhhhh - message keeps popping up

Hi

i have apples break points but can not still figure it out

is there a way i can disable the alert as application.displayalerts = false is not doing the trick

 

[Fluff]

Re: Arrrrhhhh - message keeps popping up

Try stepping through the code line by line, by using F8
That way you can see which line of code is causing problems

 

[Eisasuarez]

Re: Arrrrhhhh - message keeps popping up

ive put a breakpoint at the start of every line of code in the modules - it seems to fire this message as soon as I change my drop down box

 

[mole999]

Re: Arrrrhhhh - message keeps popping up

if it fires as soon as you change then you are either not trapping the correct module or you are not steeping through