TextBox value based on ComboBox value offset.

Hi All!

Summary: Populate text box based on the Offset (One to the right) of the value in a ComboBox, EG - B1 Contains the text 'Hello', this is the value in my ComboBox, when I select this in the ComboBox I want the cell to the right of the cell that contains Hello to be displayed in the text box below the Combo Box.

So far I have;

Please Login or Register  to view this content.

The first section;

Please Login or Register  to view this content.

Works a treat, however the second section;

Please Login or Register  to view this content.

Returns error "Run-time error '91' Object variable or With block variable not set."

Any help greatly appreciated.

Crossposted: http://www.ozgrid.com/forum/showthre...859#post625859