Need to Populate a Text box with a named range based on a value in a Dropdown Box.

Hi people

I have a Need to Populate a Text box with a named range based on a value in a Dropdown Box. We are replacing a Workbook that has become over crowded with information and I would like to make a kind of lookup table based on the value in a dropdown box. I have all the information I require in identicle sized ranges the trouble is how do I get it to add to a text box.

Thanks in Advance

Bob

To Populate 100 Text Boxes.

Please Login or Register  to view this content.

To Save 100 Text Boxes.

Please Login or Register  to view this content.