Excel dashboard and System Error

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

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.
23,719 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2020-09-06T13:23:33.21+00:00
    Dave Patrick 328.8K Reputation points Microsoft MVP

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

    No comments

  2. answered 2020-09-07T03:00:47.83+00:00
    Emi Zhang-MSFT 10,526 Reputation points Microsoft Employee

    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.

    No comments