User Form Information
 

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!!!!

User Form Information
 

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" wrote:

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!!!!

User Form Information
 

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" wrote:

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" wrote:

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!!!!

User Form Information
 

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" wrote:

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" wrote:

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" wrote:

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!!!!

User Form Information
 

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

Thank you again for your help.

"FSt1" wrote:

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" wrote:

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" wrote:

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" wrote:

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!!!!