tpoynton
12-31-2009, 09:31 AM
Greetings - have a strange problem I am trying to understand...in the attached workbook, listbox_reasons.value is sometimes blank, while using listbox_reasons.list(listindex) displays the value correctly.
In my production workbook, I get this problem every time. In the attached sample workbook, .value was sometimes only blank every other time I loaded the userform - and I find that just plain odd! :dunno
instructions for replicating the problem are in the attached workbook.
OK...as I went to put a textbox with instructions in the workbook and re-test to make sure things worked like I thought they did, the problem disappeared...I did not change any code, just added a textbox.
and then I closed and re-opened the file, the problem re-appeared. :help
SO, if you are interested, and do not see the problem the first time, I guess try closing and re-opening the file? THANKS, tim
In my production workbook, I get this problem every time. In the attached sample workbook, .value was sometimes only blank every other time I loaded the userform - and I find that just plain odd! :dunno
instructions for replicating the problem are in the attached workbook.
OK...as I went to put a textbox with instructions in the workbook and re-test to make sure things worked like I thought they did, the problem disappeared...I did not change any code, just added a textbox.
and then I closed and re-opened the file, the problem re-appeared. :help
SO, if you are interested, and do not see the problem the first time, I guess try closing and re-opening the file? THANKS, tim