LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Echo Contents of ActiveCell into a Text box.

You seem to have all the pieces; it may help to see the code you have so that
we can make it more dynamic. But I suspect that in the code you have to get
the textbox echo a given cell, all you need to do is change part of the
statement to something like:
= ActiveCell.Value
instead of whatever hard cell address you have.

You can even wrap that up in an IF statement to 'filter' on the column, as

If ActiveCell.Column = Range("A1").Column ' change A to real column ID
'your code to assign ActiveCell.Value to the text box here
End If

"ChrisR" wrote:

I want a Textbox to contain a text on a column of To Do statements - the one
the cursor is at.
I can make a textbox echo a given cell (but not a formula)
I can use a Custom function to read the current cell, but it only calculates
it once.
I cant make that cell echo or refer to the current ActiveCell dynamically
Can anyone help?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Range to echo format (hilite/fontcolors) of sister range? Schooner Excel Worksheet Functions 2 February 15th 08 07:20 AM
If activecell.column = variable then activecell,offset (0,1) Battykoda via OfficeKB.com Excel Discussion (Misc queries) 1 October 2nd 07 08:05 PM
ActiveCell or ActiveSheet Launchnet Excel Worksheet Functions 1 July 20th 07 07:46 PM
no data echo in fields Ron Oatney Excel Discussion (Misc queries) 0 January 13th 06 05:25 PM
Macro beginner - Echo Mary Ann Excel Discussion (Misc queries) 2 December 10th 05 12:41 PM


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"