Excel VBA - Flip text around EQUALS sign

[ironfelix717]

Hi all,

Have a unique little problem here that I know can be solved quite easily with some good code.

Often in my coding I am working with setting properties equal to a value and then must flip those in reverse (read versus write). For instance...

textbox1 = name1
textbox2 = name2
textbox3 = name3
texthello = hello
textExcel = Excel


Where I need to quickly generate some code that outputs:

name1 = textbox1
name2 = textbox2
...
...
..


So, I don't really know where to begin as far as what interface to use. Textbox on a sheet or form and somehow loop through each line - this seems harder than it sounds.
I need to paste multi-line text of code. I don't care how sloppy it is. Or even if the debug.print prints my results. I just need finished results. This will speed up my workflow. And yes, there are ways around this, such as naming variables in a numerical order and doing a for-loop etc, but my naming convention will be random sometimes and I need this solution.


Any ideas from the experts?

Thanks

[ironfelix717]

Hi!

I actually remedied my issue by pasting my code into the sheet and using Excel's Text-to-Columns feature and setting the delimiter to "=" to split the text. Then a simple concatenate formula to re-bind the seperated columns.


Very powerful tool that rarely lets me down.
This will save a lot of time.

However, there is some minor nuances with it. A code solution would be much cleaner I feel. I will solve the thread after some time. Perhaps someone has another interesting way of solving this problem!

Thanks

[unit285]

Hi!

I actually remedied my issue by pasting my code into the sheet and using Excel's Text-to-Columns feature and setting the delimiter to "=" to split the text. Then a simple concatenate formula to re-bind the seperated columns.

I'm having trouble understanding the problem. Could you attach a copy of your workbook? Is 'Textbox1' a cell value? or a Textbox Value? And same with 'Name1'? etc...?

[ironfelix717]

Unit285,

Thanks for replying... The problem is quite simple. I need to switch the assignment of multiple lines of code quickly.

Please Login or Register  to view this content.

Copy/Paste/Cut gets old. I remedied the solution with Excel's Text-to-Columns feature, which is OK.

However, I just found MZ-Tools, a great third party plug-in (hopefully i am allowed to mention this) that will do it VERY quickly!

Thanks - closing thread as solved