Auto populate user form from worksheet

[NRGZ]

HI,

Pretty new to VB so i'm still finding my way and I realise this may have been asked before but i cant seem to find a simple answer, here or elsewhere.

I have create a number of user forms that when data is entered it then populates specific cells within a worksheet, pretty standard stuff, what i need to try and achieve is when the user clicks on a 'previous/next' button (the user can go backwards and forwards to the other user forms) it re-populates the user form with the data that was entered.

Many Thanks in advance.
o/

 

[NRGZ]

well I thought i had a lead,

Private Sub previous1_Click()

Unload Me
finship2.Show
Call finship2.poprev1

End Sub

('poprev1' is called poprev1_click within the 'finship2' user form......)

I'm trying to run the Sub 'poprev1' that is within the 'finship2' user form, this is a command button but the sub should still execute..??, from another form but i'm getting an 'Invalid USe Of Property' error.

Ideas?

 

[NRGZ]

Any Ideas?

 

[smulttjukken]

There are different approaches to achieve what i think you are asking here. i can think of 2 that i would use for this;
1: use the multiPage control within the same userForm. search for "excel vba multiPage control" should get you moving in this direction.

2: create 1 userForm for each "page" your users need, save info to a tempDataHub from each userForm and call for the tempData when the user go back and forth between the forms. then send the final outPut into a dataHub at the last "save" button. Use the "Back" and "Next" buttons to save entered info into temData for each "page". this is more elaborate and requires more maintenance, but it offers the possibility to split up the operations if the different pages need to be complex.

hope this gets you further in you quest.

 

[NRGZ]

Thanks, I'll look into this and feedback.