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.
39,770 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Anonymous
    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 No comments

  2. Emi Zhang-MSFT 25,631 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 No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.