SpinButton problem

[Guest]

Hi fellows

I have a spinbutton on my sheet with K3 as linked cells
In J3 i generate a address to select a range with this code

Private Sub SpinButton1_Change()
Range("J3") = "A1:C" & Range("K3")
Range(Range("J3").Value).Select
End Sub

Problem is
When i hit spinbutton the selected range is only selected
evry sekond time i click the button !!! Why ?
how do i fix this ?

thanks in advanse

 

[PCLIVE]

You might try this:

Private Sub SpinButton1_GotFocus()
Range("A1:C" & Range("K3").Value).Select
End Sub

HTH,
Paul

 

[Guest]

Hole in 1

thanks alot "PCLIVE"


"PCLIVE" skrev:

You might try this:

Private Sub SpinButton1_GotFocus()
Range("A1:C" & Range("K3").Value).Select
End Sub

HTH,
Paul