Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel help for 2007 tells me that I may disable the Up-Arrow key with
Application.OnKey "{UP}","". I've placed this code in several areas, within several sub-procedures, including - UserForm_Activate() - and nothing disables the Up_Arrow key. The application that I am dealing with is in selecting a choice from a ComboBox. When I use the Slider-bar to position myself halfway through the choices - I then use the Up-Arrow to make the first choice - and I'm displaying the choice in a series of CheckBoxX.Caption (where X is an explicit number from 1 to 13). I set CheckBoxX.Value = True and fill Caption with text. When a make a second choice by using the Up-Arrow again, I explicitly set the Value and the Caption for the next CheckBox - and the system displays this AND displays a Value = True and the Caption displaying text - on the screen display of the Form. HOWEVER - when I explicitly check the third CheckBox Value and Caption, the Value is False and Caption is Null. If I then make a third selection with the Up-Arrow key - I then have a screen display of Checkbox entries that display screen entries for the last 3 selections - but in reverse order. This same reverse order presentation is present after the second selection. I'm capturing the number of selections made - 3 - however, the screen displays 6 displays of CheckBox "data" - although the extraneous displays of data for Value and Caption are out of sync with the actual contents of Value and Caption. I've written a sub-procedure that actually sets Value to False and Caption to Null prior to the Selections with the Up-Arrow - but this doesn't change the erroneous screen displays. Down-Arrow and Mouse-clicks work just fine in the selection process and screen displays. I just want to disable the Up-Arrow - but Application.OnKey "{UP}","" fails to disable the key WHAT am I doing wrong? Bob Allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Macro (VB) code for arrow down & arrow up | Excel Discussion (Misc queries) | |||
Using end-arrow down or end-arrow up in a macro | Excel Discussion (Misc queries) | |||
why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) | |||
Arrow key | Excel Discussion (Misc queries) | |||
How to do the following by pressing the down arrow or up arrow key? | Excel Discussion (Misc queries) |