Thread: Control starting value for spinner
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
vbawannab vbawannab is offline
external usenet poster
  
Posts: 1
Default Control starting value for spinner

Thanks again for the help, Bob. I obviously need to do a little mor
studying. The spinner value now goes straight to zero (my minimum) whe
I click on it. Here is what I have now. I think I need to control th
entrie process within the vba code -- not just the starting value.

Sub SpinButton4_Change()
SpinButton4.Value = CLng(Range("E19").Value)
End Su

--
vbawanna
-----------------------------------------------------------------------
vbawannab's Profile: http://www.excelforum.com/member.php...fo&userid=1678
View this thread: http://www.excelforum.com/showthread.php?threadid=31980

Reply With QuoteReply With Quote