Target.Column + 8?

[ashbee]

Hello

I have an Excel spreadsheet that will be used for data entry without userforms (to allow for Mac users). I intend on password protecting it to make data entry easier. It works as I hope however I found the code on the internet and whilst it works I don't quite understand one line of code so hoping someone can help.

In the cell change VBA code, I've put

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E5:H9")) Is Nothing And Range("B4").Value = False And Range("B3").Value = False Then
Cells(Range("B2").Value, Cells(Target.Row, Target.Column + 8).Value).Value = Target.Value
End If


End Sub

What does the + 8 stand for? If I have a differently formatted sheet I want to understand what I might need to replace the 8 with. Any guidance is appreciated.

 

[Fluff]

Hi & welcome to MrExcel
It is adding 8 to the column number where the change was made, so if you changed a value in col E (column 5) that would give 5+8 = 13 which is column M and if you changed the value in col H it would give you col P

 

[RoryA]

I have an Excel spreadsheet that will be used for data entry without userforms (to allow for Mac users)

FYI, Mac users can use userforms. (they just can't build them if they use a version later than 2011)

 

[ashbee]

FYI, Mac users can use userforms. (they just can't build them if they use a version later than 2011)

That's really useful to know. I wanted to use pop-up forms on cell selection to make it easier for them to choose from a long list of options. Thank you so much

 

[ashbee]

Thanks it's starting to make sense as I have data mapping in column M which gives the reference to the column the change should be made to BUT then how is the same +8 working if my column is G so 7 plus the 8 = 15 which is column N but I have no reference data in N?

Here is a screenshot of the columns I'm using:
https://ibb.co/M1xgXhM

I'm missing something here..

 

[Fluff]

That code only triggers if you change a value in the range E5:H9

 

[ashbee]

Thank you, I understand now! Oh the feeling of enlightenment!! I had a feeling I was missing something really obvious and I was.

 

[ashbee]

That code only triggers if you change a value in the range E5:H9

Thank you I understand now! The amazing feeling of enlightenment. I had a feeling I was missing something really obvious but this sentence helped it click into place. Thanks again

 

[Fluff]

Glad we could help & thanks for the feedback