Posted to microsoft.public.excel.programming

external usenet poster

Posts: 56

Convert Text into Formula in VBA

How can the text in one cell convert into formula?
For example, this is the text in Cells(1,1) :-

18.5x20x15

instead of using the INSTR to find each "x" , any other method?

thanks for the help in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Text to a Formula	dhstein	Excel Discussion (Misc queries)	5	October 6th 09 02:08 PM
Convert Text to Formula	Mjones14	Excel Worksheet Functions	4	July 6th 09 04:51 PM
How to convert formula to text	odd	Excel Worksheet Functions	2	December 15th 06 04:30 PM
how to convert a formula into text in order to display the formula	Claudio Hartzstein	Excel Discussion (Misc queries)	2	July 13th 06 09:58 AM

All times are GMT +1. The time now is 11:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us