Hi All,
I am new to Excel and VBA, I hope you guys can help me out.
I have an Excel file that contains a list box. The list box will load(From the worksheet activate function) all the records from the Access DB. Records from my Database will be updated every second from different parties. I want my List Box to retrieve the updatest information from the DB whenever anybody updates it. Just like a listener, once it received a new record(or updated record), then it will inform my List Box and then it's content will be refreshed during runtime.
Is there anyway to implement my idea thru VBA ???
Thank you for your help
Cheers,
Fortitude
I am new to Excel and VBA, I hope you guys can help me out.
I have an Excel file that contains a list box. The list box will load(From the worksheet activate function) all the records from the Access DB. Records from my Database will be updated every second from different parties. I want my List Box to retrieve the updatest information from the DB whenever anybody updates it. Just like a listener, once it received a new record(or updated record), then it will inform my List Box and then it's content will be refreshed during runtime.
Is there anyway to implement my idea thru VBA ???
Thank you for your help
Cheers,
Fortitude
