Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range to echo format (hilite/fontcolors) of sister range? | Excel Worksheet Functions | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
no data echo in fields | Excel Discussion (Misc queries) | |||
Macro beginner - Echo | Excel Discussion (Misc queries) |