View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
monden2 monden2 is offline
external usenet poster
 
Posts: 6
Default 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!