Thread: Creating a Button to add to existing values while subtracting range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C. A. Zan C. A. Zan is offline
external usenet poster
  
Posts: 1
Default Creating a Button to add to existing values while subtracting range
Greetings Programers,

I have be looking for some samples of how to use a button with a macro to add a value (let's say minutes) entered in cell A1.

Which upon clicking the button adds the value in A1 to an existing value of (mins.) to cell A2.

Once the total in A2 is updated, range (A3:F3) of positive values are subtracted and the results are displayed in cell B1(Mins. remaining).

I know this should be a simple one. But being new to VB, I need some help on this one. I thought I saw an example of this somewhere but can't locate it.

Thank in advance,
Chris A. Z.
Reply With QuoteReply With Quote