View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Simon Blackburn Simon Blackburn is offline
external usenet poster
 
Posts: 4
Default use a button to open a text box

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