UserForm not populating from workbook

Hi I'm new to vba. I have designed a Userform with text boxes, combo boxes and option buttons on a multipage Userform. It is running perfectly when I am in the visual basic editor using the Run Sub/UserForm. It populates the desired worksheet with all the correct data. However when I run it from a macro on the worksheet (Simple a macro to open Userform), it opens the userform properly, I am able to enter all the data as usual but it fails to populate the data into the worksheet, but performs all other commands such as clearing the worksheet. Any ideas?

I have resolved the issue. Thank you.