If Malcolm and Simons suggestions don't work you might try using target cell to activate a userform with a textbox....initialize will add the active cells value to the textbox.....

double click on one of the cells with text in column F. It works on any cell in column F