View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
reb reb is offline
external usenet poster
 
Posts: 3
Default changing a text value to a number value in a textbox?

tried formating cell in excel worksheet as a number ,still ,no help ,i can use an "if "command in vba to change 1 to 0
if checkbox1.value the
sheet1.range("a2")=
els
sheet1.range(A2")=
end i
but ,i could only get it to work with a checkbox ,and an optionsbutton ,so i'm wondering ,if it is the way a textbox is set up ,and if so ,then i'll need to find a work aroun
p.
sorry about my programming ,just started reading about it a week ago