Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply ADDRESS formula in VB
Hey Everyone,
I got a quickie here. I have made this spreadsheet code using a lot of info on here. Now I wan to use it in VB. =ADDRESS(MATCH(Sheet2!$A$23,INDIRECT("'"&Sheet2!$A $19&"'!$B:$B"),0),MATCH(Sheet2!$A$14,INDIRECT("'"& Sheet2!$A$19&"'!$A$1:$V$1"),0)) What I want to do, is have the outcome of this formula (i.e. $B$2) to be the ControlSource cell for my TextBox. It has to be flexible, meaning that if any variable change, and because of that the ADDRESS changes, it will automatically update. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply Global Formula | Excel Worksheet Functions | |||
Better way to apply a formula | Excel Programming | |||
Find Text the Apply a SubTotal Next to Text Address | Excel Programming | |||
How to apply conditional formatting with incremental address for . | Excel Worksheet Functions | |||
Apply a Macro to a FunctionKey... (again, but with correct email address) | Excel Programming |