Error hiding a combobox with a checkbox

A

apweber

I could use a little help getting around the error I am getting when
trying to hide a combobox with a checkbox. Basically, what I am trying

to do is unhide/hide rows and the rows have comboboxes in them. If I
choose a checkbox, and still have the focus set in the combobox I am
attempting to hide, I get an error. If I choose other checkboxes, and
then come back to that checkbox, I do not get the error. I will not be

the only one using this worksheet and I really need a work around. Any

help would be greatly appreciated.

The Run-time I am getting is '-2147417848 (80010108)' Method 'Hidden'
of object 'Range' failed.


When I try and debug I cannot get past the line that hides the row with

the combobox. From the worksheet I can see the proper rows hidden, but

it is somehow getting caught up. I have tried to use On Error Resume
Next with no avail. I have also tried to just add code to select a
Range in a cell nearby to get the focus out of the checkbox and that
will not work either.

I am getting the checkbox and combobox from the control toolbox.
 

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

Create form with checkbox les that expand and collapse sections of the form? 0
Getting This Unknown Error From Outlook! 1
set/get value of checkbox (controltoolbox) 1
Hiding a ComboBox with a Checkbox 2
Checkbox activate Combobox selection 1
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Blank Spaces on ComboBox 2
populate a combobox based on unique values in another workbook 16

Top