View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fredy Fredy is offline
external usenet poster
 
Posts: 3
Default VBA programming guru needed - HELP!

Hello,
i am creating a form in excel. I am not using the form
controls but rather the control toolbar (vba). I have
formulas for the different textboxes, but when there is no
data in a cell it craps out. How can i tell it to ignore
blank values? Also, why do some results not appear when i
delcare the variable as currency or integer? Anything you
know about simply adding/multiplying values from different
textboxes is greatly appreciated. I can't get the "Sum"
type of formulas to work n VBA as easy as in spreadsheet
side.?????HElp please.