How do I reference a table field from outside of the table

[dpaton05]

I have a check box that I want to enter a value in a field in a table if it is clicked. This is the code I have so far but it won't work. What else do I need to do?

Select Case chkIncrease_Click()
    Case Is = True
        index(npss_quote[10%Increase],1)="1.1"

npss_quote is the table name and 10%Increase is the column name. The table only has one line at the moment.

Thanks,
Dave

 

[dpaton05]

I tried this but it just put values all the way down the page and I want them just in the table.

If chkIncrease = True Then
Sheets("NPSS_quote_sheet").Range("m:m") = "1.1"

 

[dpaton05]

I got it working with this code

Private Sub chkIncrease_Click()
If chkIncrease = True Then
    ListObjects("NPSS_quote").ListColumns("10%Increase").DataBodyRange.Value = "1.1"
Else
    ListObjects("NPSS_quote").ListColumns("10%Increase").DataBodyRange.Value = "1"
End If


'ActiveSheet.ListObjects("NPSS_quote").ListColumns("10%Increase").DataBodyRange.Select
End Sub

Is there a better way to write it, say using a Select Case statement? How would you write it as a select case statement?