Thread: Testing for formula or value (constant)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JH JH is offline
external usenet poster
  
Posts: 64
Default Testing for formula or value (constant)
Can someone please show me how to test whether the cell is a formula or a
constant in VBA?

say in A1, if I entered a formula, '=D4*E1', msgbox will pop up and say it
is formula, and if I entered a value '1000', it pops up and say it is a value.


Thanks!
Reply With QuoteReply With Quote