UserForm using textbox as variable

[Tim Hanson]

I have a userform with three textboxes who's input I am trying to use as variables in a macro

I keep getting when

Argument not optimal

I have uploaded a file with the Userform

Thank you

 

[Nebu]

Hi:

Try changing

a(i, 2) = a(i, 2) & IIf(a(i, 2) = x, y) & _
                    .Cells(i, r.Column).Value

into

a(i, 2) = a(i, 2) & IIf(a(i, 2) <> "", x, y) & _
                    .Cells(i, r.Column).Value

I guess you were missing the parameter for IIf SQL, Again I am not sure whether it should be a(i, 2) <> "", it can be anything else based on the logic you are using. Hope this will help you to look in the right direction.

Thanks

 

[Tim Hanson]

Nebu
after alille play with what you wrote this worked

a(i, 2) = a(i, 2) & IIf(a(i, 2) = "", x, y) & _
                    .Cells(i, r.Column).Value

Thank you!!