472,145 Members | 1,624 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

a way to get from excel spreedsheet to userform

is there a a way to get from excel spreedsheet to userform? anybody? please
Jul 30 '10 #1
7 1307
1,059 1GB
I think you need to explain more
Jul 30 '10 #2
i have a user form (vba) that inputs data into the spreedsheet. but when i exit out of the userform and go into the spreedsheet there is no way for me to bring back up the userform. I have to close out of what i'm doing and reopen it. there has got to be a better way of doing this?
Jul 30 '10 #3
Guido Geurs
767 Expert 512MB
Is it possible to attach your sheet in bytes so we can better examen the problem ?
Jul 30 '10 #4
here it is once again, my friends.
Attached Files
File Type: zip AAA APPLIANCEtest.zip (41.7 KB, 45 views)
Jul 30 '10 #5
is there also a way to have the data listed within the spreedsheet go to a ticket or receipt (that looks just like the userform) in case the user needs to print it out? Just curious and looking for extra credit... I don't think anybody else would think about that one.
Jul 30 '10 #6
sny luck with my situation
Jul 31 '10 #7
ok this one I figured out.... Brain is just fried I guess. I used a macro to get back to the form.

Expand|Select|Wrap|Line Numbers
  1. userform1.show
works great. thank you guys.
Jul 31 '10 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Faith | last post: by
1 post views Thread by jimserac | last post: by
3 posts views Thread by Mark Schaffer | last post: by
3 posts views Thread by Bharathi | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.