View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Currency in Userform

Textbox1.Text = Range("A1").Text

--
Regards,
Tom Ogilvy

"Fixital" wrote in message
...
Hello,

Office 2000 on Windows NT.

Is there any way to display the "$" in a userform? I have it on the

worksheet,
but would like to display it in the textbox on the userform.

Also, I have used the "Round" on the worksheet to display only 2 decimal
places in the same textbox. Is there another way to do this?

Appreciatively, Al