Factorials

[240excel]

I need to create a program that lets user's input a number and by clicking a button it finds its factorial.

Here's what I have for now...

User is going to input number in TextBox and Press CommandButton(Here's where I'm stuck) and answer is shown in a MsgBox

I know it has to deal with possibly Arrays and Do-Loops I just don't know how to code it. I have an idea it has to deal with the Do-Loop being assigned x*(x-1) looping till x=1, but I could be wrong.

Sorry for asking help again I promise this will be my last one (or maybe one more), but that's it! Thanks.

[mccreaso]

Hi,

Use this subroutine

Please Login or Register  to view this content.

I think this will only take up to 170

You could also use the built in funtion in Excel

=FACT(A2)

either or

mccreaso

[Carim]

Hi,

What about ...

Please Login or Register  to view this content.

[240excel]

Man I am such an idiot!!!! Why didn't I go on these forums before!! Thank you!

[Carim]

Glad it fixed your problem ...

Thanks for the feedback