ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   odd problem (https://www.excelbanter.com/excel-programming/352390-odd-problem.html)

Mark Olsen

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


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com