Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I've got a little dilemma that has been driving me nuts. I have two SpinButtons on my Sheet1, what I want to do is make each button active or enabled when I click on a specific cell. e.g. only Enable SpinButton1 when I click on E9 and only enable SpinButton2 when I click on E12. I have this working quite well except for one condition. This condition is when the value of spin1 and spin2 are the same, then for some reason they both go active regardless whether I click E9 or E12. I have been call the spin enable sub from the following: Public Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) I've put in everything to make sure that buttons are only enabled when I'm in E9 or E12 and it works under every other condition but matched values? Any guidance would be greatly appreciated. If more details are required please let me know. Best regards, Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Substitute for OLE SpinButton? | Excel Discussion (Misc queries) | |||
Spinbutton | New Users to Excel | |||
Spinbutton | Excel Discussion (Misc queries) | |||
Spinbutton sorting | Excel Programming | |||
SpinButton Rounding Up | Excel Programming |