Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers