Thread: Bringing info from userform to spreadsheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_60_] mudraker[_60_] is offline
external usenet poster
  
Posts: 1
Default Bringing info from userform to spreadsheet

You are putting your answer always in Row 6


Range(col & 6 ).FormulaR1C1 =
((txtPOAmount.Value) * ((txtPOPercent.Value) / 100))


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Reply With QuoteReply With Quote