Thread: Use a formula to populate a label from a textbox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Use a formula to populate a label from a textbox
maybe:

Label1.Caption _
= Application.Text(Round(textbox1.value / 0.03125, 0) * 0.03125, "# ??/??")


damorrison wrote:

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
# ??/??

--

Dave Peterson
Reply With QuoteReply With Quote