Custom Form Shapes In VBA and Excel.

You can customise the shape of your user forms, and it’s Kewl! All the kids in my house are doing it! Look at this stupid form shape I was able to make!

CustomerShapForms.PNG

Why on earth would you want to do it I hear you ask?! That’s a very good question! When I started this I thought it was really not very useful at all. I’m still thinking that, but maybe there might be a few practical uses for it. I’m thinking tool tips and popup type things. I have covered using captionless user forms (and worksheets!), and even popup forms previously. I was never happy with the way the captionless forms looked in VBA, they look ok in VB6 but in VBA they has a wafty boarder.

Of course if you want to move over to VSTO you can even make a user form in the shape of John Walkenbach’s upper half! Is that the sound of ringing tills I can hear!

A John Shaped Form.PNG

MIE Custom Form Shapes.xls

Release.zip (Excel 2007 only + .Net 3/3.5)

Related posts:

  1. Moving a captionless userform
  2. Miss(ed) Shapes?
  3. Captionless worksheets

Comments

  1. Jon Peltier says:

    Wow, this is truly obsessive. I may have to try it myself.

  2. Nitheen says:

    Hi,

    Nice one. I really liked it.

    Happy coding in VBA

    Regards,
    Nitheen

  3. Ross says:

    Thanks Jon, it’s what Sunday afternoons where make for!

    Thanks Nitheen, have fun!

Submit a Comment