popup Calculator in a cell ?

Hi,

Love "VeniVediVelcro ..." !!!!

You can test following event macro in sheet module

HTH

James006 said:

Hi,

Love "VeniVediVelcro ..." !!!!

You can test following event macro in sheet module

Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As RangeCancel As Boolean)
Dim Program As String
Dim TaskID As Double


Program = "calc.exe"
On Error Resume Next
AppActivate "Calculator"
  If Err <> 0 Then
    Err = 0
    TaskID = Shell(Program1)
    If Err <> 0 Then MsgBox "Can't start " & Program
  End If
Cancel = True
End Sub

HTH

Click to expand...

Hi HTH

Thanx for the codecalls win calc and everything greatbut i might be nit picking here is there a way to get the result from calc without still having to insert it into the cell manuallything isi am working on a darts game scoreboard and as my friends always cheat in the game i want to eliminate the chances they have to do so. if you want i'll send you a copy so you can see what i mean.

ps: veni,vedivelcro.... it made sence when i started working in excel...lol

Is there not maybe some way to embed a vb form into the workbook for this function?

Hi,

For a userform which replicates Win Calc ...have a look at this solution:
Excel VBA - Calculator

HTH

Hi Againthanx for the calci have sort of got it working. but still have no way of getting the calc to enter the total in the selected cell automaticallyi will fiddle some more and let you know.