View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott t scott t is offline
external usenet poster
 
Posts: 6
Default textbox ,problems?

i'm try to run a textbox in a userform, to an excel worksheet , using the textbox as a number .problem is that when i send the number to excel worksheet ,it comes in a text form, which the number then won't add ,subtract ,divide ,ect
code is
Private Sub TextBox1_change(
Dim c As Rang
Set c = Worksheets("Sheet1").Range("a2"
c.Value = TextBox
oh ,i have even formated the excell -cell ,still no luck