PC Review


Reply
Thread Tools Rate Thread

How can I make an excel cell equal to the value of a frame object text box

 
 
directionalman
Guest
Posts: n/a
 
      26th Feb 2006
I recently post a question about how to apply the value of a text box
to a cell which was answered very well.

Now I am attempting to do the same thing with a text box which is a
frame object. I would like to apply the value a "frame object text box"
to a cell of another sheet in the same workbbok. This control does not
have a linkcell property as the the regular text box does. It has a
controlsource property, but that will only put data into the text box
from a cell. I would like the data to go from the text box into the
cell or into another text box for display purposes.

Thanks

 
Reply With Quote
 
 
 
 
directionalman
Guest
Posts: n/a
 
      27th Feb 2006
Sorry, the Controlsource DOES actually do this corectly. I was doing
something wrong previously.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make text in a cell equal a number =?Utf-8?B?RGFudHJvbg==?= Microsoft Excel Misc 5 23rd Sep 2007 06:10 PM
How can I make an excel cell equal to the value of a text box directionalman@yahoo.com Microsoft Excel Worksheet Functions 5 27th Feb 2006 03:12 AM
If data added to Excel cell it automatically make's another cell equal zero ianjohnmurray@hotmail.com Microsoft Excel Programming 1 19th Oct 2005 06:00 PM
How to make a cell equal text =?Utf-8?B?QWRhbQ==?= Microsoft Excel Programming 4 14th Jan 2005 11:23 AM
excel - make the content of a cell equal to worksheet name arunjoshi Microsoft Excel Misc 4 5th May 2004 09:53 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:09 PM.