Thread: How calculate a difference btwn 2 TextBox and insert the result inthe appropriate cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson[_2_] Dave Peterson[_2_] is offline
external usenet poster
  
Posts: 420
Default How calculate a difference btwn 2 TextBox and insert the resultin the appropriate cell
rng.value = me.textbox5.value

or maybe:
with rng
.numberformat = "0.00"
.value = me.textbox5.value
end with



On 11/19/2011 10:43, John wrote:
Il 19/11/2011 13:50, Dave Peterson ha scritto:
me.textbox5.value = format(me.textbox2.value - me.textbox3.value, "0.00")
Thanks Dave,
it is OK.
One more question if you allowed me:
how may update the source (the cell in column D) in the worksheet with the
Me.TextBox5.value?

Thanks and Regards
John

--
Dave Peterson
Reply With QuoteReply With Quote