Is there an equivalent to Application.EnableEvents in VB6. Can't find one in the Help file.
Is there an equivalent to Application.EnableEvents in VB6. Can't find one in the Help file.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Which events are you truying to suppress MD?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I've a form with 5 list boxes to give a multi column display. As I click on one, I want to highlight across the row. I need to suppress the Click event for the other listboxes.
I've made a workaround setting a flag to false and exiting the events accordingly, but not very elegant!
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I think that is the only way, certainly the only way I know of. It is exactly what hyou would do for a VBA userform, those events don't get covered by the EnabvleEvents setting.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
OK,
Thanks Bob.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
What's the reason for 5 listboxes instead of 1 control with 5 columns?
Cheers
Andy
Posting Permissions
Reply With Quote
