×

注意!页面内容来自https://www.mrexcel.com/board/threads/pop-up-calculator-in-a-form.64628/,本站不储存任何内容,为了更好的阅读体验进行在线解析,若有广告出现,请及时反馈。若您觉得侵犯了您的利益,请通知我们进行删除,然后访问 原网页

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Pop up calculator in a form?

afs24

Board Regular
Joined
Sep 262002
Messages
237
How do I build a pop up calculator using code? I just want my users to be able to pop up a calculator? Thank you.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Hi afs24,

Try this:
Code:
Private Sub cmd_open_calculator_Click()
On Error GoTo Err_cmd_open_calculator_Click

    Dim stAppName As String

    stAppName = "C:\WINNT\system32\calc.exe"
    Call Shell(stAppName1)

Exit_cmd_open_calculator_Click:
    Exit Sub

Err_cmd_open_calculator_Click:
    'handle error here
    Resume Exit_cmd_open_calculator_Click
    
End Sub

Hope this helps,
 
Upvote 0
Back
Top