View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default I want to make a pop up calulator in Excel.

hi
you may need to supply more info on this. but assuming that your unique
calculator was designed on a standard form.....

sub commandbutton_click()
load frmUniqueCalculator
frmUniqueCalculator.show 0
end sub

I don't this clicking a cell will do it but you can drop a command button
from the controls toolbox on the sheet and paste the above code into it. or
attach it to a custom icon.

post back if you need more info. and post more info about your unique
calculator.

Regards
FSt1

"Markman" wrote:

I have a spreadsheet that I would like to click on a cell and have a small
worksheet pop up where I have designed a unique calulator to help me with the
main worksheet. Is this possible?