View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
damorrison damorrison is offline
external usenet poster
 
Posts: 91
Default Use a formula to populate a label from a textbox

I am tryin to caption a label from this textbox with no luck

Label1.Caption = (Round(TextBox1 / 0.03125, 0) * 0.03125)


the the label has to be formated like this
# ??/??