Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    VB6 form (Excel )

    Question,
    i have a copy of VB6, but I have not created a form to use in Excel, to be honest I haven't even tried it out yet, I have always used VBA in Excel to create forms. if I create a form in VB6 how would load it into Excel?

    Thanks,
    Darryl.

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VB6 form (Excel )

    u don't.

    you would automate excel from vb 6, using the vb 6 form instead of a vba userform.

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: VB6 form (Excel )

    Does anyone a good website for creating a DLL, or a OCX, or maybe a good post in here to get started.

    Thanks,
    Darryl.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VB6 form (Excel )

    I hope someone will have a suggestion, but don't hold your breath. The focus of Woody's Lounge is mostly on Office and Office VBA, not so much on VB6.

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: VB6 form (Excel )

    You might want to have a look at KB316983 or generally browse the MSDN website.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VB6 form (Excel )

    THat article is for a COM Add-In.

    A better ap[proach is likely to use an ActiveX DLL.

    One relevant KB article is 170946, another is 18573, however, one has to have a good VB 6 book that explains how to use a class.

    Try Gary Cornell's Visual Basic 6 FRom th eGround Up.

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: VB6 form (Excel )

    That's true: it is for a COM add-in, which can be either an ActiveX dll or exe, so I'm not sure I see your point. As this is for use in Excel, why not use the add-in template included with VB6?
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VB6 form (Excel )

    A com add-in has a lot more complexity than an ordinary activeX dll.
    com add-in is overkill for most apps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •