Automatically update cell using VB code

Originally Posted by biznez

Hi everyone,

I cant seem to figure out how to calculate automatically in a sheet. For example, in cell A1 the value is 9 and in cell B1 value is 9. using vb code i want formula in cell C1 (=b1/c1). Now everytime i change the value in A1 or B1 the value in C1 automatiaclly changes.

Thanks

Are you saying that it automatically changes, and you don't want it to?

This code:

Please Login or Register  to view this content.

would put a formula in C1 that changes whenever a1 or b1 is changed

Put this in a module and assign that Sub to a button.
To insert a button go to Developer tab > Design Mode > Insert Form Controls > Button

????? by putting a formula in, the update will always happen.... why do you need a macro for this? If you really need one then forget the formula and do a sheet_change event...

Is it only the one cell that needs updating? and is it actually the cells you described?

Look, once a forumla is in the cell, it will always calculate when the other cell changes... is that not enough? if you want code to run every time, we can work on that.

A worksheet change event is a macro that runs whenever the contents of the sheet change.

You asked earlier where to put the code... let me ask this... can't you just put the formula in the cell and save the file? then it stays there...

Hello biznez,

For example, in cell A1 the value is 9 and in cell B1 value is 9. using vb code i want formula in cell C1 (=b1/c1). Now everytime i change the value in A1 or B1 the value in C1 automatiaclly changes.

Is that a typo maybe, because if you would want to do that, you would get a circular error.

Why do you need VBA for this?

Could it be that there may be more behind than, what you state in your requirement?

To help us taking guessing out of your issue, please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Regards.