VB Features Not Working

[Darren]

I designed an Excel spreadsheet with a range of VBA features, which
include check boxes and drop-down lists.

Another user has complained that when they tick a check box or select
an option from a drop-down list, their choice is not "sticking". In
other words, the tick they place in the check box goes away shortly
thereafter, and similarly, the choice they make from the drop-down
list gets superceded by the default from that drop-down list.

I have checked with the user that the macro security settings are low.
The VBA features are thus active, but are not retaining or reflecting
the actions that the user takes.

I was wondering whether anyone could shed some light on what might be
causing this.

Kind regards,
Darren

[MikeD]

Post by Darren
I designed an Excel spreadsheet with a range of VBA features, which
include check boxes and drop-down lists.
Another user has complained that when they tick a check box or select
an option from a drop-down list, their choice is not "sticking". In
other words, the tick they place in the check box goes away shortly
thereafter, and similarly, the choice they make from the drop-down
list gets superceded by the default from that drop-down list.
I have checked with the user that the macro security settings are low.
The VBA features are thus active, but are not retaining or reflecting
the actions that the user takes.
I was wondering whether anyone could shed some light on what might be
causing this.

You need to ask this in an Excel newsgroup.

[Jan Hyde (VB MVP)]

Darren <***@ptpartners.net.au>'s wild thoughts were
released on Tue, 19 Jun 2007 04:17:19 -0700 bearing the

Post by Darren
I designed an Excel spreadsheet with a range of VBA features, which
include check boxes and drop-down lists.
Another user has complained that when they tick a check box or select
an option from a drop-down list, their choice is not "sticking". In
other words, the tick they place in the check box goes away shortly
thereafter, and similarly, the choice they make from the drop-down
list gets superceded by the default from that drop-down list.
I have checked with the user that the macro security settings are low.
The VBA features are thus active, but are not retaining or reflecting
the actions that the user takes.
I was wondering whether anyone could shed some light on what might be
causing this.
Kind regards,
Darren

I think you might need more specific details from the user.