LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default list box listfillrange entity and events

Hello to anyone who can help

I am creating a little vb project in excel. It is a simple inventory system.
I have created 3 lists or arrays Listone, listtwo and listthree
I have created 3 listbox controls listonelistbox, listtwolistbox and
listthreelistbox
All three controls have their listfillrange property pointing to the
appopriate list.
I have created add and remove functionality for each of the lists.
My big problem is that I have to use a boolean value every time I remove
something from the lists
The reason for that is that when you remove the list item from the listone
for example the Listonelistbox control updates and Excel or VBA or MS
subsystem goes through each of the overridden controls code.

Could someone let me know if they have gone through something similar? I
would like to know how you got around the problem.

Kind Regards,

Shane


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identifying a uniques entity composed of two columns QuietMan Excel Programming 2 August 6th 08 02:42 PM
Finding the last value entered for an entity [email protected][_2_] Excel Programming 2 July 16th 07 02:16 PM
Finding how many events since last occurence in a database list Tony the Bajan Excel Worksheet Functions 3 November 2nd 06 10:32 PM
Export Excel File as a Complete Entity pianoman[_29_] Excel Programming 2 May 26th 06 12:44 PM
Filtered list for Combo Box ListFillRange - Nested Combo Boxes DoctorG Excel Programming 3 February 23rd 06 12:15 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"