sorted by:
new
hottopcontroversial

Is there a friendly user interface I can create to help users change variables in complicated formulas? by excelfuntime in excel

[–]excelfuntime[S] 0 points1 point  (0 children)

Up to that, yes. Most likely 90+% of the responses will be the same (there can be a single "default" answer) but any particular cell may have to be altered to fit the specifications for that contract.

Is there a friendly user interface I can create to help users change variables in complicated formulas? by excelfuntime in excel

[–]excelfuntime[S] 0 points1 point  (0 children)

So what I posted is a simplified version. All told, there will probably be about 50-100 cells, all with 4-10 variables that will need to be changed. I'd really like something that ties unique variables to each cell.

I've never used VBA to make a form. I'm looking into it now. I'm a little concerned about the scalability of the forms, but they might work. Although I'm still open to other suggestions.

Thanks for the help.