use a button to open a text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon Blackburn - 12 Jul 2007 16:12 GMT

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???

Reply to this Message

CLR - 12 Jul 2007 16:50 GMT

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

> 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???

Reply to this Message