Reference sheet2 by cell address in sheet1

Please Login or Register  to view this content.

The above is the final part of code that is part of a lookup of data in a 2nd sheet.
I am trying to gain the value in the 2nd sheet that is 30 columns offset from the selected item of the Listbox.

The Listbox has 4 columns.
1). Header(Row 1) value in sheet2.
2). A numerical value found in the Combobox1 selected row.
3). A numerical value found also in the Combobox1 selected row.
4). The actual address location of the Listbox value.

As can be seen in the code above, the Listbox Column 4 address is placed in the row above the activecell. Value inserted is formatted like ($AB$21).

The NOT CORRECT highlighted line of code, i am trying to gain a value that is offset 30 columns in the same row, and place it in the active sheet cell 4 rows down from the active cell.

How can i correctly gain this offset value?

Just another thought.
Is it possible to add to the address of the cell ($AB$21) the entire sheet and cell location?

Please Login or Register  to view this content.

I managed to solve this by actually adding an extra 2 columns to then Listbox, that populate with the offset values required.
Then simple copy those values to the other sheet instead of trying to go backwards from the bound column value in sheet2.