activeX combo on worksheet GPF with Keydown event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is this a known behavior (bug)? I have an activeX combo box on my worksheet. If the user has selected something from the combo box and then presses the enter key, I have an keydown event for the combo box that executes combobox1.visible = false and then moves to the next adjacent cell. Unfortunately when the keydown event fires, the visible = false is throwing a fatal Excel error

anybody seen this one before

Thanks
 
sorry, I forgot to mention this is Excel in Office XP Professiona

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

free text in combo box 1
Test if WorkSheet ComboBox list is open 1
KeyPreview/KeyDown not working with ActiveX 5
ActiveX comboboxes on worksheet (lost focus problems) 5
EnableEvents = False not working ??? 4
Using a Combo Box text selection to find text on another worksheet 1
how do I capture the control enter sequence in keydown or keypressed event? 2
Data Validation - Combo Box open with single click 0

Back
Top