Calculator Question

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Feb 21, 2009

• #2

Not really but try

Code:

Sub Calculator()
Dim retval As Integer
retval = Shell("calc.exe")
End Sub

 

Upvote 0

P

pujo

Well-known Member

Joined

Feb 19, 2009

Messages

710

Office Version

1. 2019
2. 2013

Platform

1. Windows

• Feb 21, 2009

• #3

Will this stay on the sheet? or will it just pop-up the MS Calc?

 

Upvote 0

dave3009

Well-known Member

Joined

Jun 23, 2006

Messages

7,146

Office Version

1. 365
2. 2021

Platform

1. Windows
2. Mobile
3. Web

• Feb 21, 2009

• #4

An addition to VoG's might be to use the inbuilt button in Excel which might bypass the use of macros

http://www.logicaltips.com/LPMArticle.asp?ID=273

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Feb 21, 2009

• #5

It just pops up MS Calc.

I think that creating a calculator in Excel would be quite difficult but this might get you started (but it isn't a calculator) http://www.tushar-mehta.com/excel/newsgroups/telephone_demo/index.htm

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Feb 21, 2009

• #6

dave3009 said:

An addition to VoG's might be to use the inbuilt button in Excel which might bypass the use of macros

http://www.logicaltips.com/LPMArticle.asp?ID=273

Click to expand...

Hi Dave

I thought there was a button but I couldn't immediately find it in XL 2007 - thanks.

 

Upvote 0

P

pujo

Well-known Member

Joined

Feb 19, 2009

Messages

710

Office Version

1. 2019
2. 2013

Platform

1. Windows

• Feb 21, 2009

• #7

I am going to research this.
I had one for an access.db and I figure that if there is one for access there could be one for excel.

Well VoG, looks like i stumped you on this one! HaHa.
You still the man!!!!

Thanks
Pujo

 

Upvote 0

dave3009

Well-known Member

Joined

Jun 23, 2006

Messages

7,146

Office Version

1. 365
2. 2021

Platform

1. Windows
2. Mobile
3. Web

• Feb 21, 2009

• #8

Making an Excel calculator would not be a great challenge, you could do it by the use of form controls or even a Userform.

I don't think you stumped VoG by any stretch of the imagination, it's more that there are plenty of calculators out there so just type 'Excel Calculator' into google and you'll get what you need.

 

Upvote 0

P

pujo

Well-known Member

Joined

Feb 19, 2009

Messages

710

Office Version

1. 2019
2. 2013

Platform

1. Windows

• Feb 21, 2009

• #9

I am going to make it a challenge for myself.
I will keep you posted on the results.
I am thinking I will create a user form first then add the functions after.


Thanks guys!!

Pujo

 

Upvote 0