View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BOBODD BOBODD is offline
external usenet poster
 
Posts: 26
Default General referencing

Ok, any perceptive people out there have realised that I'm bashing my way
through this VBA with brute force & ignorance, but I'm now trying to
streamline it.

I have this sub below:

Private Sub SpinTaxIR4_Change()
If SpinTaxIR4 -1 And SpinTaxIR4 < 5 Then
txtIR4 = "$" & (SpinTaxIR4 * Sheets(1).Range("B3")) & ".00"
Else
txtIR4 = "Enter Special Quote Here."
End If
End Sub

The problem is that I have to do this same procedure several times, but with
SpinTaxIR3, SpinTaxIR5 etc and differing cell references. How do I create a
generic routine that I can call similar to this?

Private Sub SpinTaxIR4_Change()
Range = Sheets(1).Range("B2")
Call taxCalc
End Sub

Thanks.