varying a cll value from min to max
 

Hi,

I am writing from Germany so sorry for my bad English!

I have got following problem: I want to change a value of a cell from
the minimum to the maximum in defined steps. For example: I know, that
the value varies form 5 to 10, I want to say ecel "change it in steps
of 1" and after that I can vary the value from 5 to 6 etc up to 10 by
using the mouse. My aim is that I want to see what happens if a
parameter changes from a to b.... I am thankful for answers that
include an instruction like "first click there then do this etc"
because I am new in excel. Thank you so much!

Martin


--
Martin K
------------------------------------------------------------------------
Martin K's Profile: http://www.excelforum.com/member.php...o&userid=37810
View this thread: http://www.excelforum.com/showthread...hreadid=573722

varying a cll value from min to max
 

Hi Martin,

one way is open the form bar, you will see a butom with two arrows one to up
and one to down, click on it, drawing on your sheet.

right click - Control Setup - setup as you need.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Martin K" escreveu:


Hi,

I am writing from Germany so sorry for my bad English!

I have got following problem: I want to change a value of a cell from
the minimum to the maximum in defined steps. For example: I know, that
the value varies form 5 to 10, I want to say ecel "change it in steps
of 1" and after that I can vary the value from 5 to 6 etc up to 10 by
using the mouse. My aim is that I want to see what happens if a
parameter changes from a to b.... I am thankful for answers that
include an instruction like "first click there then do this etc"
because I am new in excel. Thank you so much!

Martin


--
Martin K
------------------------------------------------------------------------
Martin K's Profile: http://www.excelforum.com/member.php...o&userid=37810
View this thread: http://www.excelforum.com/showthread...hreadid=573722

varying a cll value from min to max
 

Hi Marcelo,

thanks a lot! It works. Vielen Dank aus Deutschland. Muito obrigado
pela sua ajuda!

Martin



Marcelo Wrote:
Hi Martin,

one way is open the form bar, you will see a butom with two arrows one
to up
and one to down, click on it, drawing on your sheet.

right click - Control Setup - setup as you need.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Martin K" escreveu:


Hi,

I am writing from Germany so sorry for my bad English!

I have got following problem: I want to change a value of a cell
from
the minimum to the maximum in defined steps. For example: I know,
that
the value varies form 5 to 10, I want to say ecel "change it in
steps
of 1" and after that I can vary the value from 5 to 6 etc up to 10
by
using the mouse. My aim is that I want to see what happens if a
parameter changes from a to b.... I am thankful for answers that
include an instruction like "first click there then do this etc"
because I am new in excel. Thank you so much!

Martin


--
Martin K

------------------------------------------------------------------------
Martin K's Profile:
http://www.excelforum.com/member.php...o&userid=37810
View this thread:
http://www.excelforum.com/showthread...hreadid=573722




--
Martin K
------------------------------------------------------------------------
Martin K's Profile: http://www.excelforum.com/member.php...o&userid=37810
View this thread: http://www.excelforum.com/showthread...hreadid=573722