View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default SpinButton problem

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