If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Userform Calculator

Thread starter Jaye7
Start date May 12, 2011
Tags

calculator userform

Jaye7

Well-known Member

May 12, 2011

OK, I know that you can use scripts to call calculators such as the following.

Code:

Sub OpCalc_Click()
'Standard Module code!

On Error GoTo Err_OpCalc_Click
ActiveSheet.Select

'Open the Calculator!
Call Shell("Calc.exe", 1)

Exit_OpCalc_Click:
Exit Sub

Err_OpCalc_Click:
MsgBox Err.Description
Resume Exit_OpCalc_Click

End Sub

However, I would like to make my own userform calculator so that I can modify the way it looks, size, font etc... and can add in other things if need be.

Does someone have a worbook that they can provide that has the scripts for a userform calculator that I can then modify the look etc.... to suite my desires.

I have searched the net but haven't found anything worth while.

Thanks