I need a source code for prime number calculator VBA.

Asked By gyle kugler 90 points N/A Posted on - 04/24/2013

Hi Coders!

I have been trying to create some functions in VBA to carry out some particular tasks. At the moment, I would like to develop a prime number calculator VBA for easy pupils' online learning. Is there anyone with a source code for a prime number calculator that I can use for this particular assignment? Thanks big time for your generosity.

• Status: Open
• Question Views: 791
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Visual basic

Best Answer by Reginald E Cosentino

Go To Solution

Best Answer

Best Answer

Answered By Reginald E Cosentino 40 points N/A #154475

I need a source code for prime number calculator VBA.

Hi,

Different website provides source code for prime number calculator. However, the required code is available  or Click here . Just use this code and then run it in the JavaScript and finally you will find things are working fine. Moreover, it's very simple and easy as well.

About Reginald E Cosentino

Questions
18

Answers
26

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 05/01/2013
• Question Category: Visual basic

Answered By Wangwe Amos 0 points N/A #154476

I need a source code for prime number calculator VBA.

In Excel, you can use the following code for determining prime numbers:

Dim divisors As Integer, number As Long, i As Long

divisors = 0

number = InputBox("Enter a number")

For i = 1 To number

If number Mod i = 0 Then

                divisors = divisors + 1

End If

Next i

If divisors = 2 Then

       MsgBox number & " is a prime number"

Else

      MsgBox number & " is not a prime number"

End If

About Wangwe Amos

Questions
0

Answers
250

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/15/2014
• Question Category: Visual basic