Hanret
08-25-2013, 07:36 PM
I am new member on this site and pretty new to VBA.
I have created a MultiPage UserForm to enter a client's personal information for transfer to a Data Base. I am using 2 separate workbooks to do this - one that houses the UserForm and one that houses the Data Base. I am successfully managing to get the information entered on the UserForm to go to the Data Base.
But, I need two operations to follow when the CommandButton 'Submit' is clicked:
1) On Submit, in the first column allocate a unique number or ID to the client whose information is being submitted
2) On Submit, calculate the client's age based on the Date of Birth field entered on the UserForm
Am looking forward to your advise.
Thanks
I have created a MultiPage UserForm to enter a client's personal information for transfer to a Data Base. I am using 2 separate workbooks to do this - one that houses the UserForm and one that houses the Data Base. I am successfully managing to get the information entered on the UserForm to go to the Data Base.
But, I need two operations to follow when the CommandButton 'Submit' is clicked:
1) On Submit, in the first column allocate a unique number or ID to the client whose information is being submitted
2) On Submit, calculate the client's age based on the Date of Birth field entered on the UserForm
Am looking forward to your advise.
Thanks