In that case

spnCalc.Value = CLng(Range("A1").Value)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"vbawannab" wrote in message
...

Thanks, Bob. The user is entering values directly into cells. Ideally
I'd like to pull the value from the cell.


--
vbawannab
------------------------------------------------------------------------
vbawannab's Profile:
http://www.excelforum.com/member.php...o&userid=16784
View this thread: http://www.excelforum.com/showthread...hreadid=319806

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

Probably best to post the full code and some details of what you do and
enter in the cells etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"vbawannab" wrote in message
...

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

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


--
vbawannab
------------------------------------------------------------------------
vbawannab's Profile:
http://www.excelforum.com/member.php...o&userid=16784
View this thread: http://www.excelforum.com/showthread...hreadid=319806