combobox event [Anwsered]

combobox event

Hello,
I have an activex combox that gets populated on opening a book

cboNotes.List = [NotesList]

I couldn't figure out why a sub was called without me selecting an item in the combo, then I realized the filling of the combobox triggers this event??
Can I stop that behavior?

Private Sub cboNotes_Change()
     Call arrayLoader(cboNotes.Value, 4)
     Call chartsLoader
End Sub

Thanks

Anwsers to the Problem combobox event

You can define a public variable at the top of a standard module:
 
Public NotNowDear As Boolean
 
In the code that fills the combo box:
 
    NotNowDear = True
    cboNotes.List = [NotesList]
    NotNowDear = False
 
And in the event procedure:
 
Private Sub cboNotes_Change()
    If NotNowDear Then Exit Sub
    Call arrayLoader(cboNotes.Value, 4)
    Call chartsLoader
End Sub

Click here to download the registry repair application

Another Safe way to Repair the problem: combobox event:

Click here to download the registry repair application .

How to Fix combobox event with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will scan your system. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.

Related: Acer Laptop - BlueScreen - Windows 7,Active X.ocr How To Register The Active X Components. Error 429,Adding A Font To Word 2002,After Starting Windows The Monitor Goes To Standby (screen Is Almost Completely Dimmed/black) But The Computer Is On,Attempting To Create A Restore Point Within Windows 7 Environment.,adb exe Stop 0X00000050 Ntoskrnl exeCmmpu exe Autorun Inf Recycler Exe download rundll32 exe System32 Rundll32 Exe File Amd64ntkrnlmp exe Could Not Be Loaded The Error Code Is 7 Apoint Exe Problem hypertrm exe Pupstman exe Igfxext Exe Error acu exe stop responding using cmd kixtart main executable Applesyncnotifier Exe Download outlook extender exe error Ping Exe Virus Sqlmanager exe 8211 Application Error Largest Executable Program Size Syswow64defrag Exe Vptray Exe Xserv2k exe Protoolsle Exe Bad Image,Sticky notes not working Firefox and Chrome also freeze Transferring headers and formats from one workbook to another System Restore Not Working in Windows 8 1 Need Help What is Default Client not properly installed mean and what do I have to do to fix it The image save window can not be opened Internet Explorer This copy of Windows is not genuine 7601 the xls file format is not associated with excel on a windows 7 machine with office 2007 std when i try to associate the format i cannot choose excel The instruction at 0x00446763 referenced memory at 0x00001c04 The memory could not be written Need help with these errors Unable to connect to internet with IE8 ping request could not find host xxxxx the MTP USB Device driver doesn t install I cannot connect external devices such as i pad or Samsung Galaxy I tried multiple uninstall and re install no solution USB Devices Not Installing Software and Windows Explorer Crashing When I Right Click What caused my network adapter to not be installed or configured Vista upgrade from XP crashed had to clean install upgrade key not good for clean install the instruction at 0x682ca68b referenced memory at 0x000001c The memory could not be read What to click on in Control Panel when Microsoft Word Starter 2010 not opening USR dial up modem Modem on Hold not compatible application,New version of Google Chrome is not loading or working Login screen will not allow Ctrl Alt Del with On Screen Keyboard OSK nokia lumia 510 do not display Nepali Hindi fonts on browser how to Install Mapped Network Drive not showing for user my Internet Explorer 10 is not listed anywhere in my computer my computor will not download word there seems to be some code missing i am unable to restore to a previous time unable todownload office home and student from original cd live email not working with xp vista my system goes into power save made and i cannot get it out of this unless I power down and restart Links to another spreadsheet My wife is trying to connect to my home network but can not do so Why My shared printer is not responding to print commands from my pc Need to install my existing lexmark x1185 printer can not find a driver for windows 7 no skype since last thursday cannot sigh in no spaces between letters help my microsoft works processor is not working right Left click button not working after resume from S3 with serial mouse attached,Attempts to access Windows Update result in Code 80070424 Windows Update encountered an unknown error Running Vista Home Premium SP 2 64 bit OS asus com How to Change the amount of time before Windows 7 goes to sleep asus driver download Switch Identity Outlook Express WXP function in Windows 7 Live Mail asus driver download Problem with Windows Mail Deleted Files www asus com Start Menu and Font Size in Windows 8 1 is Changing When Waking from Sleep Mode asus driver download Windows explorer problem Stops working when I try to access my Control Panel asus com Windows Store Not Opening In Windows 8 1 SL asus drivers 3 Increase the “BIOS” category by clicking the plus signal to show the checklist of offered BIOS versions for that P5B motherboard.,Is Windows 7 troubleshooting the same as Microsoft Fix it?,DVD not recognised by windows,Audio Sample Rate and Channels,chkdsk runs automatically on start up,how do i get my computer to talk to my wireless printer