View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default error in userform

Use application.text() instead of format(). (I didn't notice it before.)



damorrison wrote:

Thanks, this works
tmp = tmp + CDbl(TextBox2.Value) should have been
tmp = tmp - CDbl(TextBox2.Value)

Dave,
your code displays the whole number then ??/16 (for the fraction) in
the label I don't know why


--

Dave Peterson