Refresh Listbox
in [Programming]
|
Prev: Feach data according to cell value
Next: thiscell
From: joel on 15 Apr 2010 07:16 Listboxes should automatically get updated if you are using Linked Cell property. The problem may be the worksheet didn't get refreshed. Do you have screen updating turned off so the worksheet did get updated which probably means the linked cell didn't get updated. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195796 http://www.thecodecage.com/forumz
From: fi.or.jp.de on 15 Apr 2010 08:00 I am not using linked cell. the data will populated to listbox from access database. Once i double click the selected listbox item, it will appear in the above text boxes, then i will change the required fields. On Apr 15, 4:16 pm, joel <joel.49g...(a)thecodecage.com> wrote: > Listboxes should automatically get updated if you are using Linked Cell > property. The problem may be the worksheet didn't get refreshed. Do > you have screen updating turned off so the worksheet did get updated > which probably means the linked cell didn't get updated. > > -- > joel > ------------------------------------------------------------------------ > joel's Profile:http://www.thecodecage.com/forumz/member.php?u=229 > View this thread:http://www.thecodecage.com/forumz/showthread.php?t=195796 > > http://www.thecodecage.com/forumz
From: joel on 15 Apr 2010 08:18
When you save the data to the ACCESS database you should also write the information to the Listbox. Don't wait until the list box is selected. If you wait until the listbox is selected then you would have to search the database again and retrieve the information. Is more than one person writing to the Access database while your userform is running. if so, then you have to refresh the listbox from the database because somebody else maybe of changed the database and you want to present in the userform (listboxes) the latest data from the database. Before you write any more code come up with a concept and archecture of what you need to do, then write the code. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195796 http://www.thecodecage.com/forumz |