Hi, I have a user form with 3 list boxes, in List box 1 I want to show the value from the active cell on the related spread sheet in List box 2 I want to show the value from cell offset C2 to the active cell and in List box 3 I want to show the value from cell offset C3 to the active cell. I have tried to use various row source VBA codes but have failed to get it right.
Any help would be much appreciated.
I am working with Windows Home Premium version 6.1.7601 SP 1 Build7601and Excel version 14.0.6123.5001 (32 bit)