display formula - selected cells only

O

okey

low hours pilot here

Ctl ` toggles the value/formula display mode for the entire ss. Is
there a way to toggle it for selected cells only?
 
J

joel

You can use a simple UDF. Put on worksheet

=getformula(B10)


the UDF is below

Function getformula(target) As String

getformula = target.Formula

End Functio
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Removing letters from cells 2
Creating a Chart on form from selected data in query. 0
Hide/Unhide with cell double click 3
formula will not show value 4
Drop down list control value in vba 2
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
Formula Audit mode active in one column only; cannot kill. 2

Top