VBA, Linking forms and feeding data from a master worksheet

[Mlanger575]

Hello

I am looking for some advice and perhaps some help with my problem.

I have created a 12 userform entry which, through unloading one form to another, feeds data and formulaes to a worksheet via a simple ActiveCell Offset (0,1) style entry. The worksheet naturally contains more data than contained in each form to perform calculations or other items which the user just doesn't need to do. For example the form allows a date of birth to be entered and the Macro operates and within the worksheet includes the current date and then a formulae to record the users age.

Next I need to bring forth some information from userform1 to userform2. However some of the steps involve more than one calculation and therefore, in the example of age, I currently have two macro buttons, one to calculate today's date and the other to calculate the age thereby allowing the 'OK'/Next Userform action to bring forth the age.

Is there a better way of structuring my work so its a lot cleaner? I have looked through the forum to see if there are any options for a string of actions in one Macro so by clicking a single button, the current date is inserted to a textbox10 and the age into textbox11 on Userform1 allowing textbox11 to be brought onto Userform2. Or I was thinking if there is a way of feeding the items from the worksheet into the Macro, so items entered and written to a worksheet through Userform1 can be looked up to Userform2.

Any help would be greatly appreciated

Many thanks
Michael

[BadlySpelledBuoy]

Is there a better way of structuring my work so its a lot cleaner?

Quite possibly, but impossible to say for sure without seeing the file. Any chance you could attach it?

I currently have two macro buttons, one to calculate today's date and the other to calculate the age

This bit rings alarm bells for me. Why do you need a button to calculate today's date? Excel already knows what that is and can be ascertained by using 'Date' in the code. For example the below code will show a message box with yesterday's date:

Please Login or Register  to view this content.

BSB