howdy,
can anyone tell me how to fix this small issue i have with the following code?
i want the error execute to run if a row of the listbox is not highlighted (clicked On) at the moment it will erase the first row of listbox if proceded
with.
Please Login or Register to view this content.
Hello.
If i understand you correclty you want to show the msgbox if the user has not selected an item from the listbox. To do this use the .ListIndex of the listbox. If the user has not selected an item the .ListIndex will be -1, 0(zero) will be the 1st item in the list.
hope this helps.
solved
the mistake was, if your interested,
if listbox1.value = "" then
it should be
if listbox1.text = "" then
Glad you got it.
I tryed to clean the code a little for you.
cheersPlease Login or Register to view this content.
Edit. The diffrence between .text and .value is when the listbox is in a unselected state .value = Null as where .text = ""
Last edited by D_Rennie; 11-30-2009 at 12:03 AM.
Thanks for your help D_Rennie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks