LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to trigger one cell change to change another cell using VB in excel? Please help! :)

I am currently embarking on a school project regarding excel and
visual basic within excel.

I have no prior knowledge to programming and my project is due very
soon so please help if you can! :)

Here's what I hope to achieve:

There are 2 columns of cells.

The value of the cells in the 2nd column will decrease given something
to trigger it.
What I hope is that the value by which the 2nd column decrease will be
added to the value in the 1st column's cells.

Does anyone know any way to do it and loop all the way downwards for
all active cells?
Please show me an example of the code and be as descriptive as you can
as I'll probably take hours to read and understand it.

Thanks a million! :)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trigger macro when specific cell doesn't change Gail Schweitzer Excel Programming 2 March 21st 07 07:28 PM
Trigger Macro on change in cell value qwerty[_2_] Excel Programming 3 April 26th 06 05:24 AM
Cell change to trigger Macro Sören_Marodören Excel Programming 2 April 11th 06 11:09 AM
Cell value change to trigger macro (worksheet change event?) Neil Goldwasser Excel Programming 4 January 10th 06 01:55 PM


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"