PC Review


Reply
 
 
ETLahrs
Guest
Posts: n/a
 
      21st Mar 2008
I have 2 combo boxes in my 12th sheet. The problem is I can't get them to
run on the load event of the workbook. I have to manually go in and run each
sub so the lists generate in them. How do I get the Wookbook_Open to run
those right away?

Thanks
 
Reply With Quote
 
 
 
 
dan dungan
Guest
Posts: n/a
 
      21st Mar 2008
I'm wondering what you tried that didn't work.
 
Reply With Quote
 
ETLahrs
Guest
Posts: n/a
 
      21st Mar 2008
I originally tried what everyone seemed to say, put the code in the
Workbook_Open event, but it was saying that the object was not defined.

I ended up changing the event in the sheet to ComboBox1_DropButtonClick() so
that the list would generate on the click event. For the second combobox,
that fills based on the selection of the fist, I just assigned the first
title for the default.



"dan dungan" wrote:

> I'm wondering what you tried that didn't work.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Load Info & Auto Compute - version 2007 Lee Ann Microsoft Access 2 17th Apr 2009 12:21 AM
Auto Load an Add-In Scott Microsoft Excel Programming 2 27th Jun 2006 11:41 PM
How do auto-load programs load? Bobby Windows XP General 1 24th Apr 2006 08:53 AM
No CD Auto Run or load trpnby Windows XP Performance 0 11th Sep 2004 05:50 PM
auto load matt rich Microsoft Excel Misc 1 9th Sep 2004 09:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:41 PM.