Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup Comment Box if a Certain Condition is Met
Hello Everyone,
Is there a way to set up a spreadsheet so if a certain condition is met, a comment box will pop up asking for feedback. For example, if a machine is running at less than 90% capacity, I'd like a comment box pop up or a row to open up below the 90% to give room for the user to enter a reason for going below 90% I don't know if something like this is even possible. Any help would be appreciated. Thanks, -Chad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup Comment Box if a Certain Condition is Met
Hi Chad,
If you insert a module in the Visual Basic Editor and paste this code in: Public Function ShowInputBox() ShowInputBox = InputBox("Please enter the reason for going below 90%.", "Feedback...") End Function then you can reference this in a cell by using a formula like: =IF(A1<90%, ShowInputBox(), "") Hope this helps. FunkySquid wrote: Hello Everyone, Is there a way to set up a spreadsheet so if a certain condition is met, a comment box will pop up asking for feedback. For example, if a machine is running at less than 90% capacity, I'd like a comment box pop up or a row to open up below the 90% to give room for the user to enter a reason for going below 90% I don't know if something like this is even possible. Any help would be appreciated. Thanks, -Chad |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup Comment Box if a Certain Condition is Met
Thanks for the help!
-Chad FunkySquid wrote: Hi Chad, If you insert a module in the Visual Basic Editor and paste this code in: Public Function ShowInputBox() ShowInputBox = InputBox("Please enter the reason for going below 90%.", "Feedback...") End Function then you can reference this in a cell by using a formula like: =IF(A1<90%, ShowInputBox(), "") Hope this helps. FunkySquid wrote: Hello Everyone, Is there a way to set up a spreadsheet so if a certain condition is met, a comment box will pop up asking for feedback. For example, if a machine is running at less than 90% capacity, I'd like a comment box pop up or a row to open up below the 90% to give room for the user to enter a reason for going below 90% I don't know if something like this is even possible. Any help would be appreciated. Thanks, -Chad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Create a condition and allows a automatic comment | Excel Worksheet Functions | |||
Popup TextBox/Comment | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions |