Free Microsoft Excel 2013 Quick Reference

Hi,

is there a way to control the value of a variable or a cell value by

using a scroll bar?

I have 3 stacked bar graphs that compare the value "Amount Invested"

with "Net Income"

of 3 different strategies.

>From the worksheet holding the graph I would like to be able to

increase/decrease the value of "Amount Invested", this value will

affect the "Net Income", and view the results.

ie I have a cell say B2, this is the data series for the top part of

one of the bar graphs "Amount Invested".

I would like to be able to increase/decrease this value by 1% for each

1% move in either direction and be able to watch the graph change as I

do this.

The upper limit for the value would be detirmined by the available

income.

When the value in B2 is calculated I would like the sheet to

automatically calculate the max amount that can be contributed and work

out what percentage B2 is of that notional maximum and put the scroll

bar in the relevant position to represent the current value.

Is this possible?

thanks in advance!

Bernie

is there a way to control the value of a variable or a cell value by

using a scroll bar?

I have 3 stacked bar graphs that compare the value "Amount Invested"

with "Net Income"

of 3 different strategies.

>From the worksheet holding the graph I would like to be able to

increase/decrease the value of "Amount Invested", this value will

affect the "Net Income", and view the results.

ie I have a cell say B2, this is the data series for the top part of

one of the bar graphs "Amount Invested".

I would like to be able to increase/decrease this value by 1% for each

1% move in either direction and be able to watch the graph change as I

do this.

The upper limit for the value would be detirmined by the available

income.

When the value in B2 is calculated I would like the sheet to

automatically calculate the max amount that can be contributed and work

out what percentage B2 is of that notional maximum and put the scroll

bar in the relevant position to represent the current value.

Is this possible?

thanks in advance!

Bernie

- Macro to increase the value of a cell each time its run
- Is it possible to increase the value of all cells in one row on the same number?
- Increase the value of a cell by a percentage
- Use vlook to show the value of a cell using a formula
- How to increase the value of the cell by some percent
- How can I get the value of a cell to increase in steps?
- Increase the starting value of a cell by an amount each day
- Text value of a cell
- How to set the value of a cell using its row and column numbers?
- Assigning the previous value of a cell to a variable
- How to assign negative value using Scroll Bar in Worksheet
- How do i update the values of variables without using the Calculate Sub
- Increase value of cell with each new sheet
- VBA: Referencing a worksheet using the value of a cell
- Plotting in Excel with a y-axis that changes with the value of a cell
- Use Value Of Active Cell To Name Row
- Using visible value of a cell for validation
- Finding max array value of variable cell range
- Increase the value in a cell simply by using the arrow keys?
- Using the Value of a Cell to Reference a Worksheet
- If value of cell +1, then value of another cell -1
- VBA - Read Values of Many Cells
- In vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell?
- Increase value of a cell in VBA

thats pretty much what i need ! LOL

thanks everyone in advance

Is it possible to do in in the MS Word table also ?

existing cell. I have a spreadsheet that has payment values in for customers.

I want to increase this amount by .08%. I have a mailmerge that creates

letters based on the amount in that cell that is why I need to keep it in the

same cell. thanks

using a formula. For example. I have entered data on Sheet 1 in cell b2. On

Sheet 2 cell b2 is a formula =IF(ISBLANK(Sheet1!b2)," ",Sheet1!b2). Since

there is data on Sheet 1, data appears on Sheet 2. On Sheet 3 I want to use

a VLOOK command that will find the value on Sheet 2 in the A column and show

the value of Sheet 2 b2.(I am using ranges, I have just simplified this for

explanation purposes) I would like to avoid referencing Sheet 1 from Sheet 3

if possible. Can this be done?

David

Thanks in advance.

value of a cell by one.

I keep a running account of my hours at work though a spreadsheet. I make sure the hours I am tracking in this excel sheet match up with the hours I have billed in another system.

The long and the short of it is, I have a cell with a value that I input and I'm trying to get it to increase every work day by 8.

So I put in a starting value.. say 40.. and every weekday, it increases that cell value by 8. Then I make sure the hours I have tracked always match that cell.

Example:

On 12/7 the value of the cell is 40

On 12/8 the value of the cell becomes 48

and so on..

Maybe there is a better way to do this or there is a template that does something like what I'm talking about?

Aside from this work tracking "solution" I am fumbling through, I would like to know the formula to increase the value of a cell by a number each day anyway..

the worksheet) how can I set the value of this cell to the value I want.

This is usally done in Access by setvalue for a control. so you send data to

the place you want. Is this feasible in Excel and how?

I've been using the following code which assigns the value in the cell that has been modified to a variable 'Result'.

VB:This may seem impossible, but I also need to assign the previous value of that cell to a variable.Range) Dim RowNo As Long, ColNo As Long, Result As String RowNo = Target.Row ColNo = Target.Column Result = Cells(RowNo, ColNo).Value End SubIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Is there a way of doing this? It's a long shot....

Cheers

Johno

Win XP Pro SP2

I use a scroll bar assigned to a cell in order to vary the value of this cell.

The range of the variable can be given in the "Properties" of the scroll

bar. For positive values this works very fine. As soon as I go towards

negative values, the displayed value in the cell jumps to 65'XXX (2 at the

power of something I suppose). How can I get there negative values? If I

itroduce them manually in the assigned cell using the keyboard, it works fine.

Thanks in advance for your advice.

I have a spreadsheet which has various formulas that are affected by a timer in cell A1.

When certain conditions are met i have a vba routine that will run an external programme dependant on the condition. The routine is part of a Private Sub Worksheet_Calculate() script but because i have 78 different if-then routines to run different versions of the software the whole thing slows down so much that by the time a 'time-flag' has been reached the spreadsheet has missed it.

I am now trying to use the routine under Private Sub Worksheet_SelectionChange(ByVal Target As Range) but i find that the variables that my vba script send to the spreadsheet are not updated until some key movement or mouse click is made in the spreadsheet itself which is not acceptable and that when my timer in cell A1=0 the script to run the external software doesn't fire.

I have 78 of these mini routines for values of P28 of 200 to 278

If Range("p28").Value = 202 Then Range("o19").Value = 0 Range("O15").Value = 0 RetVal = Shell("C:Program FilesWorkspace Macro Pro 6.5Workspace Macro Pro.exe 2-1st&3rd.wksp/u", 1) End IfCan anyone offer any advice ASAP 'coz this is driving me crazy.

I would like to use this process for other functions as well such as number the pay periods and so on.

Thanks.

I need to figure out how to reference a worksheet in a MS excel workbook using the value of a cell. For example, instead of having the line - Sheets("Test Macro Sheet").Select I want to be able to type "Test Macro Sheet" into the cell in a different worksheet and have it referenced that way.

Can anyone help with this?

Thank you.

Andy Pope did on this thread: [FONT=Arial][SIZE=3]VBA To Create Charts/Graphs From Non Continuous Ranges[/SIZE][/FONT]

, i have an excel sheet full with data and I want to plot some graphs but must depend on the variable value of a cell. The value will always be introduced in the same cell. If A3 has a value of 2, then column C should be selected (1+2 = 3 = column"C") and plotted vs. column A (x-axis data)

The value of column A will always be plotted vs. the variable columns that depend on the value of the cell. The data range would begin in row 4 because row 3 is being used to introduce the variable on the cell. This macro/code should be able to run every time that a new value is introduced to the cell. The already plotted graphs should not be deleted.

I was trying to do something like this but it doesnt work!

VB:I appreciate your help!!Range i = Range("A3").Value Dim sheetName As String sheetName = "DataSource" Dim WSD As Worksheet Set WSD = Worksheets(sheetName) finalRow = Range("A65536").End(xlUp).Row Dim dataString As String dataString = "R4C1" & ":R4C" & (1+i) Set rngChtData = WSD.Range(dataString) Set rngChtXVal = WSD.Range("$A$1:$A$finalRow") Charts.AddIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

If cell a1 has value = June. I want to change the name of row 1 to June.

I'm not sure what I'm doing wrong with the following code.

Sub Name_a_row()

'

'

Dim TheName As String

Dim RowNum As Integer

TheName = ActiveCell.Value

RowNum = ActiveCell.Row

ActiveWorkbook.Names.Add Name:="TheName", RefersToR1C1:="=Data!R&RowNum"

End Sub

Thanks for the help.

This is most likely a simple problem.

I have a sheet where the user must input a date (dd-mm-yyyy). Based on this date, an adjacent cell displays the name of the weekday (I do this by copying the value of the original date, and displaying the cell as "dddd".

I would very much like the value of this cell to be the name of the weekday, as I have another cell which checks to see if the inputted date, is (for example) a tuesday. I do this by using:

VB:This doesn't work though.(CELLA="tuesday";"TRUE";"FALSE")If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

I had hoped that there was a copy/paste option to only copy the visible data of a cell, but no.

Does anyone have any tips on how to do this? I have searched for something similar, but was unable to find anything.

cheers,

Peter

PS. I included a small example, it's very simplified, maybe it's excessive, but it might help explaining what's going wrong.

I'm currently stuck in trying to find out to get a max array value

from a variable cell range,

the data is divided in 5 collums, and the variable cell range should

be dependent upon the first column. the maximum value should be

available from column c to e. the first colums has blanks in between

of variable spaces. I need to get the maximal amount of the array

based upon the id code in first column (including the row of the id

code, excluding the row of the second id code)...

example:

A B C D E

12341 data data data

12341

42343

23432

does anyone had a clue how to fix my problem (offset, dmax or

anything) ?? I really don't know how to fix this problem,

thanks in advance!!

best regards

Anyone know how I can use the value of a cell to determine what worksheet I collect data from?

History:

I have one tab that is basically a calendar that lists the days as 1-31. For each day, I am completing numerous calculations based on the data associated with that day.

I also have 31 tabs. One for each day. I input the daily data on the respective day.

I do not want to have to change the formulas for each month and well, as much as I would like the 1st to always be on the same day, it just isn't happening. So come Feb I will need to change the weekday that the 1st falls on (the rest of the days will change automatically). this is why I can't just use =SUMIF('1'!$H:$H,"MILE",'1'!$S:$S). I can't hard code '1' as the worksheet, I need it to reference the cell that contains the date, say H3 for the sake of an example.

I tried something like:

=sumif((value(H3))!$H:$H,"MILE",(value(H3))!$S:$S)

I need the worksheet name in the formula to be dynamic.

Any suggestions?

I need it to function in Excel 2003 since it needs to run at work.

Thank you very much in advance, and I apologize for any confusion or obvious ineptitude at Excel!

... but that's not desirable either because the cell locations are then hard coded. Can someone suggest another solution?

particular sheet changed? some kind of event? how to get the old and new

value of the cell?

No luck finding an answer? You could always try Google.