View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Virtanis Virtanis is offline
external usenet poster
 
Posts: 1
Default Macro Button To Modify A Cell's Contents?

I'm just starting to look into VBA to help me do things with my excel
project, but for the most part, I'm a beginner and totally stumped.

Here is my problem.

On Sheet2 I have a whole range of figures and numbers displayed which
are pulled from a variety of other pages (say =Sheet1!E2 as an
example). This is an overview page mostly.

What I really need is to make a macro button next to a display field on
sheet2 that, when pushed, will modify the the actual contents of the
Sheet1!E2 cell by -1. Each push of that button will minus 1 from that
cell indefinitely.

I'm such a programming novice, I hope someone could take a moment of
time to explain how to do this. Thank you very much.


---
Message posted from http://www.ExcelForum.com/