Excel dashboard and System Error

Roar Thorvaldsen 1 Reputation point
2020-09-06T07:43:29.387+00:00

Hi all,

I am currently trying to build a Excel dashboard where I use some visual basic codes.

The code is supposed to visualise a infobox when one click on a info button. The VB code is built (hopefully) in such a fashion that it is easy to scale throughout the dashboard to enhance the experience.

When I click on the info button the sysem error show on picture pops-up.

22813-vb-error.png

This is the VB code if uses:

----------

Function Change_Info_Box_Visibility(Info_Button As Object, Info_Box As Object, Visible As Boolean) 

If Visible = True Then  
    Info_Button_Inactive.Fill.ForeColor.RGB = RGB(255, 255, 0)  
    Info_Box.Visible = True  
Else  
    Info_Button_Inactive.Fill.ForeColor.RGB = RGB(255, 255, 255)  
    Info_Box.Visible = False  
End If

End Function

Sub Change_Info_Box_brand_Visibility() 

With ActiveSheet  
    If .Shapes(“Info_Button_Brand”).Fill.ForeColor.RGB = RGB(255, 255, 255) Then  
        Call Change_Info_Box_Visibility(.Shapes(“Info_Button_Brand”), .Shapes(“Info_Box_brand”), True)  
    Else  
        Call Change_Info_Box_Visibility(.Shapes(“Info_Button_Brand”), .Shapes(“Info_Box_brand”), False)  
    End If  
End With

End Sub

----------

Does anyone have any suggestions on how I could solve this?

Best regards
Roar Thorvaldsen

Windows 10, O365, VB applications 7.1

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,882 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426K Reputation points MVP
    2020-09-06T13:23:33.21+00:00

    Excel development is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
    https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments
  2. Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
    2020-09-07T03:00:47.83+00:00

    Hi @Roar Thorvaldsen ,
    Q&A is not supported Office for Development problem, I suggest you post this issue to Excel for Developer forum:

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments