Not sure of what to call it accept (Un - concatenating)
 

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

Not sure of what to call it accept (Un - concatenating)
 

Hi Tom
depens on your chosen delimiters. You may have a look at the Split
method in the VBA help. But you should choose ONE delimiter for all
parts.
alternatively use a combination of Left, Mid and Right together with
InStr

--
Regards
Frank Kabel
Frankfurt, Germany


Tom wrote:
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 Then
strcyl = OptionButton1.Caption
ActiveCell = "-" & strsph & "x" & strcyl
End If

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

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