use a button to open a text box

[Simon Blackburn]

Im using Excel 2007 and what I want to do is this. I want to create a button
on my worksheet so when the work sheet is active, i can press thiss button
and a text box will open where i enter a number. This number will then be
stored somewhere (untill the button is used again and a different number
entered) and used reference to a formula (sum) on the worksheet. Anybody
wanna tackle this one???

 

[CLR]

What you are asking for with the Pop-up window will require VBA code. Do you
want to add code to the workbook for just this function?.....if not, you can
still accomplish what I percieve you are trying to do by just modifying your
formula to include a helper cell, or a NamedRange, either of which could
contain the current number to be added to the formula.......this way youi
would always be able to see what the last number was before changing it.

If your formula is =A1+A2, modify it to read

=A1+A2+MyNumber (where MyNumber is a named range)
or
=A1+A2+Z1 (where Z1 is the helper cell)

hth
Vaya con Dios,
Chuck, CABGx3