Hi,

Ideally I would like to show the drop down on screen,
print the selected content but not the box or dropdown arrow.

do not print the dropdown. "calculate" the selected value and write it
into a cell that will be printed.

what I usually do is the following: at the top of every data source of
a dropdown I have two cells - "selected item no." and "item". selected
item no. is filled when you change the value of the dropown, it's a
feature of the dropdown menu, it will be 1,2,3...whatever. "item" is
the corresponding entry. It would look like this:

John <== Formula you need, cell A1: =offset(a3,A2,0,1,1)
3 <== selected item no., Cell A2
MyFriends (Cell A3, Just a headline)
Jim
Jane
John <== selected in dropdown
Jerry

HTH
arno