Locking list boxes

[IvanJames]

Hello,

I am modifying a form that was created on a Worksheet (not a User Form), and have placed several list boxes on the form. For some odd reason, several of the list boxes appear to be locked after I reset the form, somewhat randomly. it seems to be the same several list boxes that do it, but some do it more than others. I have made sure they weren't locked in properties, but they seem to do it slightly less when I change it to locked in properties. I have made sure that no cells touching the list boxes are locked when protected. If anyone can help I would greatly appreciate it!

[Norie]

What do you mean 'locked'?

[IvanJames]

When I click on it nothing happens.

[IvanJames]

I'm just really confused n why this happens with some of them, but not others.

[Norie]

How are you populating the listboxes?

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[IvanJames]

I don't think I am allowed to do that at work, but I will check to see. I am loading them using a hidden cell range. BN14:BN15, for example.

[Norie]

There's only 2 items in the listboxes?

[IvanJames]

Here is the sample. The list boxes titled "Full Baths", "Adverse Factors", and "Beneficial Factors" seem to be the biggest problems. If they work the first time, click on RESET FORM at the top and they will likely not permit clicking. The password is Aw_2012. Thanks!!

[Norie]

They work fine for me as long as I'm not in Design Mode.

You can toggle Design Mode on and off on the Developer tab.

[IvanJames]

Can you try it a few times? Even when not in design mode, they lock for me after reset almost every time.

[Norie]

I have tried it a few times and the only time the listboxes appeared locked was when I first opened the file.

When I toggled Design Mode they all started working normally even after clicking the reset button.

Mind you there is something strange going on, when I go into Design mode, right click a listbox and select Properties then the property sheet is blank.

I think that might be because the VBA project is locked though.

By the way, do you have any protection on the sheet/workbook?

PS Can the user make more than one selection in the listboxes?

[IvanJames]

Can you confirm that you were clicking the list boxes under the Adverse and Beneficial Factors labels? They seem to be the biggest offenders.

To get rid of the blank properties you have to click Developer/Controls/View Code and type in the password Aw_2012. I guess the VBA protects separate from the worksheet. I turned off the worksheet protection before sending, and it should only trigger if you click the copy comments button. The list boxes are set to only allow one selection.

[Norie]

I tried all the listboxes, including the those for Adverse and Beneficial Factors.

I've also had a quick look at the code and I can't see anything that could be causing the problem.

[IvanJames]

Weird. I've had others in office check and it is also happening to them. Do you think it could be a difference between Excel '07 (what I'm using) and '10?

[Norie]

I'm using Excel 2010 and I'm also getting the locked listboxes

Also I can't think of any version changes/differences that could cause the problem.

[IvanJames]

Oh, I thought you said you weren't getting them. This is so strange and frustrating. People are counting on me to get this done. I'm right there at the end and may have to scrap the whole thing and start over

[Norie]

No I am getting them when the workbook first opens but if I flip in and out of design mode everything is fine.

[IvanJames]

Yeah it seems if I do something to "trick" it, like change a setting in the properties, it works at least once before resetting. However, this will be used by 100 people so I can't have it be like that. I do really apprecaite you taking the time to help though.

[Norie]

Did you change any of the 'default' property settings for the listboxes?

[IvanJames]

I've changed IntegralHeight, MatchEntry and Locked.

[Norie]

Not sure if they would have any bearing on the problem but when I get home I'll have another look.

[IvanJames]

Thank you, I appreciate it!

[IvanJames]

Is it possible to put something in the reset code that will make the list boxes activate? I'm guessing that only one at a time can be activated, but maybe there is something that can be put in the code to help?

Currently I'm using this to reset them:

Please Login or Register  to view this content.