Excel listbox properties

[Didon]

I haven't dealt with these things in a while, so this may be a dumb question. I have an absolutely dreadful spreadsheet some underwriters put together that I'm trying to understand. I thought I could right-click on a listbox to find out where its values were coming from or where its output was going or something like that. Nothing happens when I right-click on any of the listboxes in this spreadsheet. I've already unprotected both the workbook and the worksheet. Any ideas?

I'm also having trouble figuring out where the radio buttons and checkboxes are going -- I don't know if I'm supposed to be able to right click on those either.

[BassFreq]

It may be a Control Toolbox Item rather than a Form item. Try this:
1. View > Toolbars > Control Toolbox
2. Click on Design Mode (first one, with blue triangle and pencil like in MS Access)
3. Right click on object and select Properties (not Format Control).
4. For data source on a list box, look for the listboxfill property.

[cubedbee]

Sounds like your listbox is from the control toolbox, not from the forms menu. Go to View>Toolbars>Control Toolbox>Design Mode to allow you to right click it and get to the properties.

[Didon]

Thanks guys. I followed your advice but it's still not working. Nothing happens when I right-click. I guess I'm going insane.

[BassFreq]

Is it a real drop down or a validation drop down?

Use the arrow keys to navigate the cursor to select the cell behind the dropdown. Then in the menu go to Data > Validation > Settings. Is there a source listed?

Another idea- what happens when you right click on a cell instead of a listbox?

Also, have you checked to see if there is any VBA in the workbook that may have created this situation?

[Griffin 6]

Originally Posted by BassFreq

Is it a real drop down or a validation drop down?

No fair. I was going to say Validation Drop Down.