Is there anyway to load information into a listbox and a combobox as soon as I open the workbook? I need some kind of workbook_open event, but I can't seem to figure it out.
Is there anyway to load information into a listbox and a combobox as soon as I open the workbook? I need some kind of workbook_open event, but I can't seem to figure it out.
Go to the "thisworkbook" object in the VBE (From excel right click on the
Excel icon beside File in the menu and select view code). There are two drop
down boxes just above the code window. Change the one from General to
Workbook. A code stub for the open even will be added automatically. The
other drop dwon lists all of the events you can work with.
--
HTH...
Jim Thomlinson
"kev_06" wrote:
>
> Is there anyway to load information into a listbox and a combobox as
> soon as I open the workbook? I need some kind of workbook_open event,
> but I can't seem to figure it out.
>
>
> --
> kev_06
> ------------------------------------------------------------------------
> kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
> View this thread: http://www.excelforum.com/showthread...hreadid=547904
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks