Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm new to working with Controls. I put a Spinner control from the Control
Toolbox on my worksheet. The Spinner action and the code work fine (the code copies a range from Sheet3 and pastes it into Sheet1 which has the Spinner). But it seems like after clicking the Spinner and running the code, the focus will be alternately on the sheet (application title bar with color, active cell has "selected" border), then on the spinner (title bar grayed out, no active cell, dotted line around Spinner control) - back and forth, every other time. The last lines of code are wks.Range("A1").Select wks.Activate hoping to force the focus back to the worksheet, but it's not working. Is there a property I have set incorrectly? Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Option Button/Focus Problem on Worksheet | Excel Programming | |||
Complex focus problem | Excel Programming | |||
spinner linked cell problem | Excel Discussion (Misc queries) | |||
Focus problem | Excel Programming | |||
weird focus problem | Excel Programming |