View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BigDave[_9_] BigDave[_9_] is offline
external usenet poster
 
Posts: 1
Default inputBox if cell " ?


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