Is it possible to create a form using VBA script. I want to populate it with as many controls as indicated in a variable cnt

You can use

controls.Add to add the control you want

then you need to position them accordingly

If you want to create a userform from scratch, try if VBComponents can help you. I have used it for creating a module (http://vbadud.blogspot.com/2008/10/p...-to-excel.html)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)