Hi there.

This is my first post here, but I've had a search before and I couldn't quite find exactly what I was looking for. (I'm also not very good with vba as you will probably gather shortly)

I am running a userform off a checkbox. The userform is essentially a pop out of a load of input boxes. So far so good. However, when I change a value and then hit the cancel button i've created, that value still changes the input before unloading the userform.

Is there a code I can use for the cancel button itself to ignore any changes in the input box on the user form, before unloading and changing the spreadsheet data?

An alternative I was thinking about was including an if statement for all the input boxes stating something along the lines of:

if cancel = true then
inputbox = *cell reference*
end if.

What do you think?