Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Show Formula Contest Automatically
PHV: Thanks for quick response. It seems it is not working - have you tried it? Regards, iv- iv63
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Show Formula Contest Automatically
Let’s say variables a and b are defined in cells B1 & B2. Cell B3 has a formula 2a+b/3 (=2*B1+B2/3). I want in cell C3 contest of this formula (2*1+2/3) not (=2*B1+B2/3). This can be done manually like this ="(2*"&TEXT(B1,0)&"+"&TEXT(B2,0)&"/3)". The following Sub shows formula contest...- iv63
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Show Formula Contest Automatically
Thanks PHV for the quick response. Your function returns cell formula =2*B1+B2/3 instead of =2*1+2/3 (with values of cells B1 and B2). Regards, iv- iv63
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Show Formula Contest Automatically
BTW I have "improved" Macropod's Sub by replacing MsgBox .Formula & vbCr & strFormula with ActiveCell.Offset(0, 1) = "'" & strFormula I think with Sub you have to run Macro every time you change the formula's parameters. Correct? With function in cell C3 I would have =myFunction(B3) which will...- iv63
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Show Formula Contest Automatically
For example let’s have variables a and b defined in cells B1 & B2. Cell B3 has a formula 2a+b/3 (=2*B1+B2/3). I want in cell C3 contest of this formula (2*1+2/3) not (=2*B1+B2/3). This can be done manually like this ="(2*"&TEXT(B1,0)&"+"&TEXT(B2,0)&"/3)" (basically I want the VBA function that...- iv63
- Thread
- Replies: 13
- Forum: VBA Visual Basic for Applications (Microsoft)
