Hi all,
I am a beginner in Excel VBA. I've problem with my list box in Userform VBA whereby my list box is not refreshed in everytime I searched for another ID. Is that any solutions to refresh my list box in everytime I clicked for new search?
I've attached my file at here...
Many thanks in advance~
Last edited by Excel_Kidz; 08-29-2011 at 08:09 AM.
Do you mean clear previous items from the Find All listbox?
Please Login or Register to view this content.
Where should I put the codes as above in the FindAll listbox to clear previous data and go for new search?
In the cmbFindAll_Click event.
I smply added the clear command to you existing code.
Sorry that my problem still exist... I've inserted the codes as you given to me... but still not clearing...
Last edited by Excel_Kidz; 08-29-2011 at 08:11 AM.
I did try to apply it in my Findall event but still can't refresh my list box
Looks like the clear code works fine, but you've (MRA) changed the code so that it duplicates Column A
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You are not clearing the variable MyArray, so it can contain the result of previous searches.
Hmmm, what should i do to make the findall event refresh the listbox in every search? thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks