Creating form Programmatically in the module using vba-excel

hy. i want to create a user form in the module using vba programmatically. i am novice and inexperience so i have tried couple of examples but they are not fullfilling my requirements.
i just want macro that

> creates user form created in module using vba
> has a listbox with some data
> a CommandButton with a listener

Bingo That's All. please its urgent...

See attached file where I added a module with a macro.
If you want to run code on new excel file you need to add a reference.
Open Visual Basic Editor (Alt + F11), choose Tools, References and add 'Microsoft Forms 2.0 Object Library' or click on Browse and select c:\windows\system32\fm20.dll file.

This is the macro if you can't download the file:

Please Login or Register  to view this content.

Regards,
Antonio

Originally Posted by antoka05

See attached file where I added a module with a macro.
If you want to run code on new excel file you need to add a reference.
Open Visual Basic Editor (Alt + F11), choose Tools, References and add 'Microsoft Forms 2.0 Object Library' or click on Browse and select c:\windows\system32\fm20.dll file.

This is the macro if you can't download the file:

Please Login or Register  to view this content.

Regards,
Antonio

Awesome Man. Than you so Much. There should be a treat for you. One more thing i would like to ask, i.e. when i run that module it creates a UserForm at vb side as well. and when ever i again run it generates the userform sequence. could there be a function that when that macro runs a userform is created and when it is UnLoaded that userform finishes.??

Why not just create the userform manually. This seems like an awful lot of work for something as trivial?

To delete form at form unload you could add these lines:

Please Login or Register  to view this content.

Regards,
Antonio

Thank You All. You All Really Deserve a treat(On Your Own. LoLzz). Thanks to All once again