Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenating | Excel Worksheet Functions | |||
concatenating | Excel Discussion (Misc queries) | |||
Concatenating % | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Concatenating | New Users to Excel |