Make calculations into a program

[Tinwelende]

I've got a few cells where anyone can insert the gene code (geotype) of any two hamsters (male + female) and Excel will calculate the possible outcome of the gene codes (genotypes) and colors (fenotypes) of the offspring. It's using calculations of thousands of cells, so the process of calculating all this is quite slow, but I've finally managed to make it work perfectly. But now I want to transfer all this into a program, so that the user sees a simple program where he or she can add the genotypes and then the program does exactly what Excel does, only it looks a lot more simple (and program-like) to the user. Is there any program like this out there where one can just import an Excel ducument and choose what cells are not to be shown and what cells that are supposed to be able to be changed by a user?

[protonLeah]

web search: "excel to exe converter"

[Tinwelende]

I did and I can only find programs that makes people unable to change the formulas in Excel. I want it to be a separate program of its own and not Excel that opens. I want an .exe-file to open and in there you can insert your data and hit "Run" or "Calculate" and the results appear. I can't find that type of converter anywhere.

[FDibbins]

I did and I can only find programs that makes people unable to change the formulas in Excel

Im pretty sure that is the whole point of those conversion programs. If you want to edit excel formula, use excel

[Tinwelende]

But I want a program that people can use. They are not supposed to know I've used Excel formula. They just need a simple program to use. That doesn't exist?

[FDibbins]

See if this link is any help to you...

http://www.mrexcel.com/forum/excel-q...t-xls-exe.html

But again, as I said, if you want the users to be able to edit excel formulas, getthem to use excel

good luck

[popipipo]

Maybe you can use a 'userform'
I know that this can be made 'screenfilling'

My knowledge of this is not good enough to help you.
Maybe someone else

[Tinwelende]

That also just converts the file to exe within Excel. I don't want to see Excel at all in the final product. I want it to be a simple standard gray window that comes up with only the text and the cells I choose to appear there, where people can insert their information.

But thanks anyways, though. If there is no such solution as the one I'm looking for, I'll have to go for keeping it within Excel, as you suggest.

[Tinwelende]

A "userform" sounds like something like what I'm looking for! (I'll Google it). Thank you!

[Norie]

You could use a userform, and hide the Excel workbook (and Excel) behind it.

The user enters the required data on the userform, that data is then transferred to the workbook where the results can be calculated and then they can be displayed on the userform.

[Tinwelende]

Does that require for the user to manually open Excel and such, back and forth? Or does the userform pop up once that Excel document is opened? It needs to be as simple for the users as it can possibly be.

[Norie]

Not sure what you mean about opening Excel 'back and forth'.

As soon as the user opened the workbook the form would popup and Excel would be out of sight as it would be hidden.

Code behind the userform would do everything else, eg transferring data from form to worksheet, retrieving results etc.

[FDibbins]

But that still requires excel to be present on the host machine?

[popipipo]

Take just a look at this how it is working and not what is showing.

[Norie]

popipipo

Why not add Appliction.Visible = False to hide Excel too?

[popipipo]

It is just an example
You may tune it the way you want.

[protonLeah]

This thread is the same as this one