Aug 14 2006, 10:59 AM
I am trying to reverse engineer a spreadsheet that I have been given to debug. The spreadsheet has several combo boxes on it. Each time I right click on the 'down' arrow nothing happens. I unprotected the sheet. I also am displaying the Toolbox and clicked on the 'Design Mode' button, and still when I right click the control I don't get the little design window for the control. What am I missing?
Aug 14 2006, 11:07 AM
Perhaps it's a control from the Forms toolbar?
Or perhaps it isn't a control but has been created using Data>Validation...?
Edited by: norie on Mon Aug 14 12:07:35 EDT 2006.
Aug 14 2006, 11:42 AM
Thx Norie, I've just learned about Data Validation! I used Edit>GoTo>Special>Data Validation and it highlighted all the data validation cells. So I clicked in the cell and then went to the menu bar, clicked Data>Validation and up comes some info. There's more... Now I know about 'naming' lists...I just needed a little push, thx again.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here