Hello,
Users are complaining that a workbook (that contains a Click Event ComboBox) keeps debugging.
It appears that when the users copy or move sheets from another workbook into the workbook with the code in, then the Click Event is activated - even though no user interaction has occurred in terms of the combo box.
Can anyone suggest a solution as I am going crazy with this?!
Thank you
Neil
Neil
Where is the combobox located and how is it populated?
If posting code please use code tags, see here.
Thanks Norie (great name by the way)
The combobox appears on its own in a worksheet.
It is populated by using the Properties (right click..> Properties) for the ComboBox by setting a range for the data in the "ListFillRange" property
Are you using a dynamic named range for the ListFillRange?
Are you referring to a defined name range? If so yes I am using a defined name rather than the 'vanilla' method of setting a cell range reference.
Neil
What could be happening is that when the user is copying/moving worksheets the named range is bring recalculated and that is triggering the combobox's click event.
If that is what's happening you could avoid it by populating the combobox using code.
For example you could put something like this in the module of the sheet the combobox is on.
Please Login or Register to view this content.
That's amazing, you've solved it! Thank you so much Norie.
Neil
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks