I want this all to happen behind the scenes, without users seeing the process.
Open Recordset("tbl Words", db Open Forward Only) Options.
One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.
The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.
Hi, I've got a listbox which populates a second listbox from cells on a hidden worksheet which is done through macros.
Every time I select a value in the listbox, the screen "flickers" to the hidden worksheet.
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.