Hi everyone

below I have a bit of code that gets changed constantly and places a string value in a cell. To get to this point the user needs to go through several userforms. There are 400 possible locations for this bit of code and 1,000s of combinations it can equal.

If OptionButton1.Value = True The
strcyl = OptionButton1.Captio
ActiveCell = "-" & strsph & "x" & strcy
End I

Example of the result in cell B5: -1.25x-1.0

My question is, is there a way to pull this apart at a later time

I'm looking too grab each of the four components above and place them in four different cells in another workbook

I appreciate any help that anyone can give

Tom