Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

Extracting values from Freeform shapes

I am trying to make a separate data sheet that collects numbers I type into
the Freeform shape text box. For example,

In one of the sheet called "08-02-08" there is a freeform shape named as
"Freeform 26".
In this text dialogue I'd like to type a value of "26" and I want this text
value to transfer over to a sheet called "Data Collect Sheet" cell "A1"
automatically.

If anyone knows how to accomplish this task it would be a great help for me
to let me know. Thank you.

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
Extracting Values and inserting Rows/Values	VexedFist[_2_]	Excel Programming	3	April 22nd 08 02:37 PM
Area of freeform shapes	Dave Shaw	Excel Programming	15	January 4th 08 06:14 PM
Pick list or freeform text	PJH	Excel Discussion (Misc queries)	2	March 30th 06 05:11 AM
How do I refer to a freeform name and number on a chart using VBA	Raas	Excel Programming	4	November 23rd 05 06:21 PM
Freeform shapes	Jackie[_5_]	Excel Programming	2	June 8th 05 05:40 PM

All times are GMT +1. The time now is 08:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us