View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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