View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default SpinButton problem

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