Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spinbutton | New Users to Excel | |||
Userform SpinButton problem | Excel Programming | |||
Spinbutton | Excel Discussion (Misc queries) | |||
spinbutton? | Excel Programming | |||
SpinButton Problem | Excel Programming |