Originally Posted by
healthwatch
Could you explain to me how the VBA gets the information from sheet 1 i.e name and WTE
The below is taken from the code provided
So to clarify further:
Target:
this is the cell on which you double clicked (ie Bx where x is row) ...
(ie a Range)
wsForm:
this is declared in the code as a Sheet Object and has been assigned as Sheet4
Offset:
Will offset from a given range by specified rows / columns, eg:
So going back to the actual code:
Sets Cell B6 on Sheet4 to be the value of the actual Target cell
(ie the contents of the cell you double clicked - name)
The below
Sets Cell I7 on Sheet4 to be 37.5 * the value of the cell Offset from the Target by 1 Column (ie Cx where x = row)
Bookmarks