Results 1 to 16 of 16

Thread: VB.NET forms and controls for VBA/VB6

  1. #1

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    VB.NET forms and controls for VBA/VB6

    To unify Visual Basic, a VB.NET assembly has been created for consumption by VBA/VB6. It provides access to many VB.NET objects, ie forms, common controls, and common Namespaces. Feedback of any sort is welcomed.
    Github: https://github.com/WindowStations/VB6NameSpaces

  2. #2
    Lively Member IndicSoftware's Avatar
    Join Date
    Aug 2017
    Location
    India
    Posts
    70

    Re: VB.NET forms and controls for VBA/VB6

    Hi,

    Which version of .NET runtime is required to use this?
    --
    From,
    Indic Software


    Revolutionary Visual Programming IDE.


    The ultimate tools to build web applications painlessly without coding.

  3. #3

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    It uses legacy framework 2.0 for compatibility out of the box. Targeting 3.5 is also possible. It was developed and compiled with VS2008 architecture edition.

  4. #4
    Hyperactive Member
    Join Date
    Aug 2020
    Posts
    350

    Re: VB.NET forms and controls for VBA/VB6

    It's very valuable work. Thank you very much, TTn.

  5. #5

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    Thanks, I think the hardest part was figuring out how to use Reflection to return a string representing a Com-exposable class. Then, it all falls into place. It was gratifying to have the code run right away, without much effort after that lol.

  6. #6

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    BTW, the VBA environment requires a reference to VB.tlb. The prefix on VBA would be VB.Button, rather than VBCtl.Button, as it is on VB6. I tested this on Office 2007, Office 2016, and Office 2019, 32bit and 64bit.

  7. #7
    New Member
    Join Date
    Jun 2017
    Posts
    5

    Re: VB.NET forms and controls for VBA/VB6

    The video is too blurry to be useful.

  8. #8

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    Quote Originally Posted by cidtek View Post
    The video is too blurry to be useful.
    Sounds like your bandwidth is running slow, or this is the first time showing on the local server.
    The HD setting on youtube defaults to auto. Try setting it manually to 1080, ie the gear icon on the bottom right corner that says (HD).

  9. #9

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    A form designer has been created to work together with the internal assembly of VB.NET controls.
    The designer can be used as a standalone exe, but it will also be integrated into the VB6Porter addin, so that the designer can insert code and events directly into the module.

  10. #10
    Hyperactive Member
    Join Date
    Aug 2020
    Posts
    350

    Re: VB.NET forms and controls for VBA/VB6

    I tested it and it's great.

    Calling components developed in other languages can greatly expand the advantages of VB6-IDE and the scope of application of the VB6 language.

  11. #11

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    The designer works well in tests so far. Refinements have been made to integrate the controls more smoothly. The process of laying out controls is virtually identical to vb.net now. Several improvements have been made to the assembly since the first preview.

  12. #12

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    Reloading the designer with the new VB6 designer formatting was more challenging than I first estimated, but here is a video showing the usage in action.
    A few components are still not populating the toolstrip items correctly, but I'll sort that out soon enough.


  13. #13
    Hyperactive Member Episcopal's Avatar
    Join Date
    Mar 2019
    Location
    Brazil
    Posts
    256

    Re: VB.NET forms and controls for VBA/VB6

    Forgive me, but have you created a new IDE? That's what I saw in your video ....

  14. #14

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    Quote Originally Posted by Episcopal View Post
    Forgive me, but have you created a new IDE? That's what I saw in your video ....
    It's more of an extension to the VB6 IDE, allowing one to design VB.NET forms, controls, and utilize related namespaces. I am working on integrating it seamlessly into the IDE along with the VB6 addin. The integration uses a dll assembly to expose VB.NET classes to VB6. The assembly includes a designer that is referenced by the vb6 addin, so that events can be raised between them to communicate.

  15. #15

    Thread Starter
    Fanatic Member TTn's Avatar
    Join Date
    Jul 2004
    Posts
    625

    Re: VB.NET forms and controls for VBA/VB6

    The functions for opening and saving designs will support integration and stand alone use. The selected VB6 class modules can be opened and saved with the integrated designer. The developer will be able to switch between designer and class code. The current limitations are that only one instance of the designer can be running at a time, as SDI.

  16. #16
    Frenzied Member
    Join Date
    Feb 2003
    Posts
    1,369

    Re: VB.NET forms and controls for VBA/VB6

    Feedback of any kind? You can upload uncompressed files to GitHub. It makes for easier browsing. GitHub auto-zips them when you download a folder.

Posting Permissions

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



Click Here to Expand Forum to Full Width