i just want to know how to finish it off that's my problem and thanks for the advice
in the future, use attachments to show the layout of the form, and code tags to show the code.
[ code ] insert code here [ /code ]
Just remove the spaces inside the sq. brackets
also break up your text so we can tell what your trying to say, the entire this is 3 "sentences."
Looking through the pictures, i see 2 pics of the layout which doesn't matter, and 1 pic of code. the code is terribly formatted and has several syntax errors.
you simply do not have
If a = b Then c = d
If a = e Then c = f
you need to have
If a = b Then
c = d
Elseif a = e Then
also, I'm not seeing anything relevant to your problem here... If this is your entire code, then you have several undefined variables. I'm going to assume that OptYen is a radio button for Yen, meaning that you need "OptYen.Checked" instead of "OptYen = True"
The underscores are only for wrapping, for example, if you have a massive command, you "wrap" it onto the next line by ending the first line with an underscore