View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Formula in VBA!!!

without any validation at all:

with activesheet
msgbox .range("b7").value * .range("b8").value
end with



PCOR wrote:

Using VBA what syntax do I use to Take the figure in B7 and multiply it by a
figure in b8
Thanks

--
Norton Professional 2004 says this email is clean...believe it


--

Dave Peterson