Skip to Content

How to use FOX formula to accept user input in an Excel workbook?

Apr 10, 2017 at 10:46 PM


avatar image
Former Member

Hello Everyone,

Currently I'm working on an integrated planning workbook on Excel, with Analysis for Office Plug-in. I'm trying to realize a function so that user can click on the planning function button in the workbook, and manually input a factor (maybe through a prompt window if it can be made), and then the planning function will revaluate the planning numbers by the factor user input, rather than hardcoded percentage in the planning function.

Can this function be realized by using Fox formula? As far as I understand, the variable functions in FOX do not accept user input. If so, any workaround?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers