View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cellist cellist is offline
external usenet poster
 
Posts: 24
Default Passing Userform Control to Subroutine

I want to pass values from a userform textbox to a subroutine by reference so
that the subroutine can pass back the result into the textbox.

doEqual tbResult1.Value, tbInput1.Value

Private Sub doEqual(resultAmt, inAmt)

This runs OK and debug "watch" values show the correct amount in resultAmt
and InAmt, but tbResult1.Value remains unchanged. Is this a syntax issue,
or???

TIA,

Phil