View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
-Zoki- -Zoki- is offline
external usenet poster
 
Posts: 5
Default VBA - Disable up down movement inside ListBox


"NickHK" wrote in message ...
Will this confuse your users ?
Sometimes UP works, sometimes not. The user will have to understand why,
otherwise they will think it is 'broken'.


Users are usually confused, but they will learn :-).
And I can always put some message box with information what is happening.
I need this option because I need to perform some actions
in exact order so I need controlled movement in listbox.

In this case that I have now in list box are listed path to images (jpg).
On same user form I have image window.
When I select image path in list box , this image is displayed in
image window.
Images are located on server and sometimes is needed cca 1s to display
image after selecting in list box.
So if user press too fast up and down arrow keys it is possible that
some images are skipped (not displayed in image window) and
this situation I want to avoid.

So I want that when user press, let say key down, in list box image path is selected,
in image window soon image will be displayed.
But until image is not displayed I want to disable up-down key.



Zok