User Form Information

[stockwell43]

Hello,

Does anyone know of a supre great Book and or Website for User Forms in
Excel using VBA?

I would like to create a user form to look like a nice document so when the
user inputs the information they can print it and it will look professional
instead of a big gray box. Then after print, I would like to click a button
to close the form and empty or delete everything that was inputted or do a
save as etc...

Any help would be most appreciated!!!

Thanks!!!!

 

[FSt1]

hi
this should get you started.
http://contextures.com/xlUserForm01.html

you can also do a gooble on excel user forms or similar. lot of info out
there on this subject.

Regards
FSt1

 

[stockwell43]

Hi Fst1,

Thank you for response. Yes, this will definitely get me started. Will this
also work with 2007? I have both 2003 and 2007.

Thanks!!!!

 

[FSt1]

it should. i don't think they changed that much on user forms.
but add this site as cross refference
http://msdn.microsoft.com/en-us/library/bb211363.aspx

regards
FSt1

 

[stockwell43]

This looks like the ticket, excellent information!!!!

Thank you again for your help.