Free Microsoft Excel 2013 Quick Reference

Increase/Decrease Value of variable/cell using scroll bar?


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
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!

Post your answer or comment

comments powered by Disqus
macro to increase the value of a cell each time its run

thats pretty much what i need ! LOL

thanks everyone in advance

Is it possible to increase the value of all cells in one row on the same number, for example on 10?

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

How do i increase the value of a cell by a percentage and keep it in the
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

I would like to use the VLOOK formula to show the value of a cell that is
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?

I am trying to increase the value of cells by certain percentage. example i have a worksheet with some data in cells C6 to F20 with different numbers. i want to increase all the cells by 5% , is it possible?.

Thanks in advance.

I want a formula where in a logic statement, I can automatically increase the
value of a cell by one.

I apologize if this is addressed in another post. I've been searching for this answer in a few different forums including this one and none of the answers seemed to cover exactly what I was trying to do (or I just didn't understand it). Hopefully, someone can help me through here

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.

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..

how can I return the text value of a cell useing"sumif" formula

If I have the row and column number s of a cell (calculated in one part of
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'.

    Dim RowNo As Long, ColNo As Long, Result As String 
    RowNo = Target.Row 
    ColNo = Target.Column 
    Result = Cells(RowNo, ColNo).Value 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This may seem impossible, but I also need to assign the previous value of that cell to a variable.

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


Excel 2003 SP3
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.

My question is: "can i have values changed live on my spreadsheet by a vba function such as -Range("O19").Value = 0- when a timer in cell A1 reaches certain values without any user interaction?"

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

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 If
Can anyone offer any advice ASAP 'coz this is driving me crazy.

I was wondering if it was possible to increase the value of a cell each time a new sheet is created within a workbook. For example, I created a series of events with reoccurring dates (2nd through the 15th), on the next sheet I continued the dates (16th through the 29th). If another user creates a new sheet in the future can the copied sheet then continue the patter automatically (30th and on) without having to change the first date manually?
I would like to use this process for other functions as well such as number the pay periods and so on.


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.

Hi, I am kind of new to vba. I am trying to do basically the same as
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!

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") 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I appreciate your help!!

I'm trying to take the value of a cell and use the value as a name for the row.
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.

Dear All,

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:


If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This doesn't work though.
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.



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

Hi All,

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)...


12341 data data data




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

I would like to be able to increase the value in a cell by 1 by using the up arrow key. Obviously, the default action in Excel is to move up to the next cell. Is there any way to change this, perhaps with a plug in?

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


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:

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.

I am creating a spreadsheet/inventory count and wish to create a formula. First, we have general merchandise, and then we have pre-packaged kits which contain multiple items together, ready to ship and counted as 1 "pre-packed" unit. So if cells B1:B10 contained the values of how many individual parts/items we currently have, and then B11 was the number of prepacked units, is there a formula so that when the value of B11 is increased (lets say by 1), then the values of B1-B10 decrease by 1? I want it to decrease the values of B1-10 by the amount that the value of B11 increases. So if I increase the value of B11 by 22, all the mentioned cells would decrease by 22 consequently.

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

Excel 2003 > I am developing a comprehensive VBA function that needs to read the value of many cells in a worksheet. I don't want to Name all those cells because then I will need to pass too many variables to the function. I can use the following set of objects and properties ...
... but that's not desirable either because the cell locations are then hard coded. Can someone suggest another solution?

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?

I wish to increase the value of cell A1 by 1. How do I do this ?

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