How to use MS Flex Grid in Excel vba form

Discussion in 'Microsoft Excel Programming' started by Mika, Nov 3, 2010.

  1. Mika

    Mika Guest

    Hi guys

    I have VB 6, and need to use the Ms Flex Grid control on a VBA form
    within Excel.

    However the incorporation of the control into the form is rejected
    with the message "unsafe..." which normally occurs if you dont have
    the license for it (or don't have VB 6 installed) which is not my

    In the forms in VB 6 environment, I don't have any problem.

    Does anybody know how to use (load) the cotrol on the Excel form?
    Mika, Nov 3, 2010
    1. Advertisements

  2. Mika

    GS Guest

    Mika was thinking very hard :
    When the userform is active in design view, right-click the Toolbox and
    you'll be able to add additional controls. It will, of course, be
    necessary to distribute (and register) the control with your vba
    project in order for it to work on other machines.
    GS, Nov 3, 2010
    1. Advertisements

  3. Mika

    Mika Guest

    GS, I didn't explain it clearly.
    There is not problem to add the control to the toolbox as you
    describe. The error appears when I try to put such control FROM the
    toolbox into the Form. Then, it is not accepted.
    Mika, Nov 3, 2010
  4. Mika

    GS Guest

    It happens that Mika formulated :
    I see. I don't get that when I draw the control on a userform (or
    drag/drop it there). It seems to work just fine for me. Maybe you could
    provide more info like which version of Excel you're working in and the
    version of MSFlexGrid.ocx you're trying to use.
    GS, Nov 3, 2010
  5. Mika

    Mika Guest

    Just for the records, in case somebody got the same problem, I was
    able to solve it in the most unusual way:

    - First: yes, I do have a legal version of VB 6 installed, and as I
    said I can work in VB and the Flex grid without problem.

    I found that in another excel form my Common dialog control stopped
    working as well, getting the error; "Class not registered...", on top
    of that, another control used: Tree list, had the same error.

    Therefore I re-registered both controls, with regserv32, and voila !
    the MS FlexGrid began to work! I didn't have to register the MS
    FlexGrid control.

    What is the reason ?. I have no clue.
    Mika, Nov 4, 2010
  6. Mika

    Harald Staff Guest

    Ah good. For the records, sorry I misunderstood your problem. It usually is:
    A userform like that will not run on other computers that doesn't have VB6,
    even when the controls are properly installed and registered.

    Best wishes Harald
    Harald Staff, Nov 4, 2010
  7. Mika

    GS Guest

    Harald Staff formulated the question :
    Sorry Harald, but I disagree! Also for the record, I use VB6 controls
    quite a lot in Excel VBA projects and they run without problem on any
    machine I install the project to. Seems they only require being
    registered on the target machine (regardless of where they're installed
    on that machine). I can't speak for all VB6 controls used in MSO VBA
    projects, but the ones I use most often are:


    ...all of which work just fine.
    GS, Nov 4, 2010
  8. Mika

    GS Guest

    Harald Staff has brought this to us :
    I can say that I have had problems in the past with different versions
    of these controls, in different versions of Excel. Seems I have been
    able to (over time) come up with the right versions to use in my VBA
    projects. Now that I primarily use VB6 COMAddins, my Excel projects are
    now pure VB6. This, of course, is not always the case since some
    clients specify their solutions be VBA.

    Knd regards,
    GS, Nov 4, 2010
  9. Mika

    Bill in Las Vegas

    Jan 11, 2017
    Likes Received:
    Do I have to have Visual Studio installed, or can I just make FlexGrid available in VBA in Excel by downloading it and registering it in syswow64? Is anyone using it that way? And, if so, does it keep the component in the spreadsheet, or would I have do do the download/register for any user's machine? Sorry to be so ignorant about this...
    Bill in Las Vegas, Jan 11, 2017
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.