PDA

View Full Version : show formulas in Excel Vba



ganeshr
08-10-2011, 10:25 PM
Hello there. would you please Suggest me the code in VBA to show the formulas in different cells.

Trebor76
08-10-2011, 11:22 PM
Hi ganeshr,

This will put the active cells' formula into a message box if there's a formula in the active cell:


If ActiveCell.HasFormula = True Then
MsgBox ActiveCell.Formula
End If

HTH

Robert

ganeshr
08-11-2011, 09:40 PM
Thanks a lot. It works.

Trebor76
08-11-2011, 09:43 PM
Thanks for letting us know and you're welcome :)

ganeshr
08-11-2011, 09:54 PM
Thank you. One more request please.

ganeshr
08-11-2011, 09:59 PM
In Excel if i change the input value of one variable or an attribute by certain percentage, What will be the effect of the same on end variable?

Bob Phillips
08-12-2011, 01:12 AM
In Excel if i change the input value of one variable or an attribute by certain percentage, What will be the effect of the same on end variable?

Try it and see.