Thanks for this. BUt what i want is that the input message
should show in the second set of cells, not as a pop-up
box but as data in the cell itself.


-----Original Message-----
Putting the input message in a separate column might
confuse the users,
but to do that:


Select the cells that contain the data validation, and
copy them
Select the cells in the adjacent column.
Choose EditPaste Special
Select Validation, click OK

Select the first set of cells with validation
Choose DataValidation
Select the Input message tab
Remove the check mark from the "Show Input Message when
cell is
selected" box
Click OK

Select the second set of cells with validation
Choose DataValidation
Select the Settings tab
From the Allow dropdown, choose 'Any value'
Click OK

akk wrote:
Hi

I have a spreadsheet that shows a pop-up box, when i
place
the cursor on a cell. For every cell in a column there
is
a different pop-up box(looks similar to a comment, but
is
not a comment) which has the description. How has this
been done? Also, how do i have the contents of the pop-
up
box in a separate column.

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.