Hi P45cal,
Thanks for replying.
On the "Home" Tab I have a series of buttons, which open various sheets, each button opens a specific sheet, and I don't have any problems with them, - but the one button opens a userform which has two options, to either open a sheet that has an input form on it, or the other to capture the data from the input form.
The code above is in the userform code module.
I could create two separate buttons to do what I want, but as they are both related to each other I thought it would be cool to go this approach ( If I can!!)