Hi-
Textbox1 shows the number listed in range(A1").
Private sub userform1.activate
textbox1.text = range(A1")
end sub
My question is how do you show that if range "A1" reads $1.23, then I want textbox1 to read $1.23 and not 1.2333333 upon activating the textbox?
Textbox1 shows the number listed in range(A1").
Private sub userform1.activate
textbox1.text = range(A1")
end sub
My question is how do you show that if range "A1" reads $1.23, then I want textbox1 to read $1.23 and not 1.2333333 upon activating the textbox?