blackie42
01-14-2009, 05:30 AM
Hi,
I'm trying to get a userform to do 2 things and having trouble.
I'm using 'with activesheet' to commit the value of a number of textboxes
to a sheet called CMFSPLIT. I also want it to commit the value of another
couple of textboxes to another sheet called CMFRUN.
I want to do this for a number of paired sheets and trying the following which isn't working cos I know its wrong - but can't figure out how to fix it
If ActiveSheet = Worksheets("CMFSPLIT") Then
Worksheets("CMFRUN").Activate
Range("c16") = TextBox85.Value: Range("E16") = TextBox86.Value
End If
Any suggestions welcome
thanks
Jon
I'm trying to get a userform to do 2 things and having trouble.
I'm using 'with activesheet' to commit the value of a number of textboxes
to a sheet called CMFSPLIT. I also want it to commit the value of another
couple of textboxes to another sheet called CMFRUN.
I want to do this for a number of paired sheets and trying the following which isn't working cos I know its wrong - but can't figure out how to fix it
If ActiveSheet = Worksheets("CMFSPLIT") Then
Worksheets("CMFRUN").Activate
Range("c16") = TextBox85.Value: Range("E16") = TextBox86.Value
End If
Any suggestions welcome
thanks
Jon