Thread: odd problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Olsen Mark Olsen is offline
external usenet poster
 
Posts: 8
Default odd problem

Hi,
Im fairly new to visual basic for applications and Ive come across a
weird occurance. I have 2 list boxes set up and use , < , , << buttons
to transfer a text string from one list box to the other. Basically the left
listbox has a bunch of options and the right one is the selected options.
There are all kinds of these in various wizards and things. Well, when a Run
button is pressed, it reads the entries from the right list box and performs
the appropriate actions. The problem is that sometimes it will not read
anything out of the list box. (Im using the listbox2.value to get the
string). Its so weird because sometimes it works and sometimes it doesnt
even when run under the exact same conditions. A lot of times, it will work
when I put messageboxes in to track values. This makes me think that
somehow, some data is stuck in a buffer somewhere and needs to be flushed. A
msgbox i guess happens to do a flush and thats why it works with them. Any
ideas?

Mark