Refresh Listbox
in [Programming]
|
Prev: Feach data according to cell value
Next: thiscell
From: fi.or.jp.de on 14 Apr 2010 16:00 Hi All, I have excel userform, which is connected to access database. I have customer details in access dabase. I will search using excel userform, results are displayed in listbox. I will select the listbox item and update the required details. If I click save it saves to database. That is working fine. What I need is, If click save it need refresh the listbox item also with saved details. Is this possible. ??
From: Bob Umlas on 14 Apr 2010 16:08 me.repaint "fi.or.jp.de" <fi.or.jp.de(a)gmail.com> wrote in message news:c83f5f18-1720-4f69-a1f4-cce1c3046610(a)8g2000yqz.googlegroups.com... > Hi All, > > I have excel userform, which is connected to access database. > > I have customer details in access dabase. > > I will search using excel userform, results are displayed in listbox. > I will select the listbox item and update the required details. > If I click save it saves to database. That is working fine. > > What I need is, If click save it need refresh the listbox item also > with saved details. > > Is this possible. ??
From: fi.or.jp.de on 15 Apr 2010 05:44 No its not happening Assumed i listbox showing status as pending, I click on that & change it to completed. & Clicked save. It will be updated in access database. I want to reflect the changes in listbox after the update. On Apr 15, 1:08 am, "Bob Umlas" <rum...(a)kpmg.com> wrote: > me.repaint > > "fi.or.jp.de" <fi.or.jp...(a)gmail.com> wrote in message > > news:c83f5f18-1720-4f69-a1f4-cce1c3046610(a)8g2000yqz.googlegroups.com... > > > > > Hi All, > > > I have excel userform, which is connected to access database. > > > I have customer details in access dabase. > > > I will search using excel userform, results are displayed in listbox. > > I will select the listbox item and update the required details. > > If I click save it saves to database. That is working fine. > > > What I need is, If click save it need refresh the listbox item also > > with saved details. > > > Is this possible. ??- Hide quoted text - > > - Show quoted text -
From: joel on 15 Apr 2010 06:13 How is your listbox filled? Are you manually adding entries or using the linked cell property of the listbox. 1) If you are using a linked cell then you have to put the data onto the worksheet for the listbox to get updated. 2) If you are adding the data into the listbox using code then you have to add the entry into the listbox using VBA code. The listbox doesn't magically get updated without adding instruction into your macro. -- 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 06:47
what code need to be added to get updated. On Apr 15, 3:13 pm, joel <joel.49g...(a)thecodecage.com> wrote: > How is your listbox filled? Are you manually adding entries or using > the linked cell property of the listbox. > > 1) If you are using a linked cell then you have to put the data onto > the worksheet for the listbox to get updated. > > 2) If you are adding the data into the listbox using code then you have > to add the entry into the listbox using VBA code. > > The listbox doesn't magically get updated without adding instruction > into your macro. > > -- > 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 |