In my worbook have a column of 20 cells. Any one of the cells, up t
all 20, can have text in them. If there is text in those cells,
want/need an inputBox to appear so that a comment can be typed in. Th
result of the input box will go to a cell out of sight on the same pag
of the workbook in a relative location to the 20 cells.
I've thought about having commandbutton next to each cell so that th
user could select which one she/he wants. That much vba I know and ca
do. The other thought is to press a single button and programmiticall
search out the text filled cells and prompt the user for a comment (
like this idea a bit better), but only if the comment can be place
relative to cell that prompted the action
--
BigDav
-----------------------------------------------------------------------
BigDave's Profile:
http://www.excelforum.com/member.php...nfo&userid=774
View this thread:
http://www.excelforum.com/showthread.php?threadid=37816