a way to get from excel spreedsheet to userform

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vbanewbie2
    New Member
    • Jul 2010
    • 35

    #1

    a way to get from excel spreedsheet to userform

    is there a a way to get from excel spreedsheet to userform? anybody? please
  • johny10151981
    Top Contributor
    • Jan 2010
    • 1059

    #2
    I think you need to explain more

    Comment

    • vbanewbie2
      New Member
      • Jul 2010
      • 35

      #3
      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?

      Comment

      • Guido Geurs
        Recognized Expert Contributor
        • Oct 2009
        • 767

        #4
        Originally posted by vbanewbie2
        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?
        Is it possible to attach your sheet in bytes so we can better examen the problem ?

        Comment

        • vbanewbie2
          New Member
          • Jul 2010
          • 35

          #5
          a way to get from excel to userform

          here it is once again, my friends.
          Attached Files

          Comment

          • vbanewbie2
            New Member
            • Jul 2010
            • 35

            #6
            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.

            Comment

            • vbanewbie2
              New Member
              • Jul 2010
              • 35

              #7
              Originally posted by ggeu
              Is it possible to attach your sheet in bytes so we can better examen the problem ?
              sny luck with my situation

              Comment

              • vbanewbie2
                New Member
                • Jul 2010
                • 35

                #8
                ok this one I figured out.... Brain is just fried I guess. I used a macro to get back to the form.

                Code:
                userform1.show
                works great. thank you guys.

                Comment

                Working...