Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inputbox calculations and "outputbox" | Excel Discussion (Misc queries) | |||
inputBox calculations and msgbox or "outputBox" | Excel Worksheet Functions | |||
Compile Error in Excel 2004 when Inputbox contains "VBCRLF" | Excel Discussion (Misc queries) | |||
excel.application.run macro1 -- added code to respond "yes" to a inputbox | Excel Programming | |||
InputBox or...to allow nubers formulas and Ranges I mean "Type:=0+1+8" | Excel Programming |