Thread: Form buttons
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Homer Homer is offline
external usenet poster
 
Posts: 9
Default Form buttons

Hi,

I've added some buttons on a spreadsheet to increment and decrement
a number contained in a cell. The trouble is, I need the number to be able
to be positive or negative. The options on the setup tab only allow for 0
upwards. Is there a way to decrement below 0?

I figure I could start at say A1=500 and make another cell ie A2=A1-500
but this would make things overly complex. I wondered if the range can be
set more easily?

Thanks,

Nick