SpinButton problem
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
"excelent" wrote in message
...
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
|