Full Version: edit a control in a spreadsheet
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
Nyteshade
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?
norie
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.
Nyteshade
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.