Inserting the DataGrid control? (Excel VBA) RRS feed

  • Question

  • Hello I would like to know how can I insert an additional control to the DataGrid on the UserForm.

    Because I was in Tools> Additional Controls.

    But I found the dll DataGrid. How can I find it?

    I have Visual Studio installed and updated frameworks.

    Thank you for your attention.
    I await response.

    Monday, December 23, 2013 9:58 PM

All replies

  • Hi,

    According to your description, you want to insert a control into the DataGrid of a UserForm.

    I think your issue is more related to the VBA development, I'd like to move it to VBA forum so that you will get the most qualified pool of respondents, and other partners who read the forums regularly can share their knowledge.

    Thanks for your understanding.

    By the way, VBA user form is developed by the Visual Basic Editor which is different from Visual Studio.

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, December 24, 2013 6:01 AM
  • Hi Felipescc,

    Did you have any chance to look at the similar forum thread?

    Tuesday, December 24, 2013 9:10 AM
  • In VBA you do not have DataGrid, but You can use Listbox from standard control or CC controls from mscomctl.ocx named ListView Control.

    You can add it using Toolbox: (right click)

    Important is reference in your system.

    If you'll any problems, you should use regsvr32.exe to register control.

    Oskar Shon, Office System MVP -
    if Helpful; Answer when a problem solved

    Wednesday, January 1, 2014 12:38 PM