excel calculator type function

I currently have a sales order form in excel. It basically assist customer service in creating a quote. Long term I am planning on moving to access/VB, but for now this works. My problem is they said it would be nice if they could have a calculator pop up on top of the form.

It would not be a real calculator, all it needs to do is take a length and width and convert it to square meters (input is in either inch or mm).

They only use this once in a while, so I do not want to add more columns that will confuse them.

My only thought so far is to create a true VB control that could do this and insert it into the excel template.

Any other ideas, or is this my best bet?

Thanks!!!

So you are saying you want it to appear on the current form instead of a second form appearing? Then you are probably right, do it in VB.

If I am interpreting your question correctly, you could just add a userform from VBA and put your code there.

That is what I was hoping to do (add a user form), but is that avaliable in 97? I am not sure how to do that with VBA.

Thanks.

<P ID="edit"><FONT class="small"><EM>Edited by pells on 07/23/01 01:03 PM.</EM></FONT></P>

Open the visual basic editor from Tools Menu - Macro.
Right click on the VBAProject in the Project Explorer Window and select Insert - UserForm. Rename it, design the interface, add code. Add a Public Sub ShowCalcForm() in the ThisWorkbook module. It has one line of code MyCalcFormName.Show. You can run this sub to test your form. Back on your worksheet go to View menu and toolbars. Select Forms and from the forms toolbar click the command button and draw on your sheet. It will ask you the name of your macro. Put in ThisWorkbook.ShowCalcForm.
Hope this make sense.

Simple as insert forms images/icons/laugh.gif.

Now I might be dangerous.

Thanks!