Date not updating in excel worksheet
You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hi Everyone, I am having a formula in Cell B5 and I want to put the result of this formula in Cell A5. Cell A5 should contain the result of formula written in B5. Then I want to copy the same formula down to other cells . Thanks Hakim I'm not quite sure I understand the motivation for the specific functionality you are requesting. There are a few pieces you need to make this technique work. Click on the left hand dropdown at the top of this module, and select Private Sub Worksheet_Change(By Val Target As Range) With Active Sheet. You need a chart, a set of values for the scaling parameters, and some VBA code to change the axis scales. Why, out of interest, are you averse to having the string stored as the result of a formula as opposed to a hard-coded value in a cell? If you refer to a cell containing a formula and test on its value the result of the formula is what is passed and not the formula itself so it should be identical. However, if I understand your request, you'd like to hard-code the value result of a formula in one cell into another cell.
Maccas i am wondering if there is a way to continue the code i have here Private Sub Command Button1_Click() Active Sheet.
something of this sort meaning if a certain condition evaluates to true then write the result as work done in A5. and this particular formula is copied right down the excel sheet.
meaning B6 will have formula ($a="yes", A6="work done") . Please help urgently quote: Originally posted by hakimk Hi Everyone, I am having a formula in Cell B5 and I want to put the result of this formula in Cell A5. Cell A5 should contain the result of formula written in B5. Then I want to copy the same formula down to other cells . Thanks Hakim In that case you cannot do specifically what you want with Excel sheet functions alone.
Or you can manually adjust the axis scales; when the charted values change, you must manually readjust the scales. We can use the has appeared automatically atop the module.
Wouldn’t it be great to be able to link the axis scale parameters to values or, even better, formulas in the worksheet? If you want a ready-to-use solution, try Tushar Mehta’s Auto Chart Manager add-in, available as a free download at You can write the entire procedure yourself, but it’s easier and more reliable to let the VB Editor start it for you.
These properties can be set equal to constant values, to VBA variables, or to worksheet range or named range values, as illustrated in this code sample: If you have a Line, Column, or Area chart with a category-type X axis, you can’t use the properties shown above.