UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> edit a control in a spreadsheet    
 
   
Nyteshade
post Aug 14 2006, 10:59 AM
Post #1

UtterAccess Ruler
Posts: 1,289
From: Ohio, USA
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?
Go to the top of the page
 
+
norie
post Aug 14 2006, 11:07 AM
Post #2

UtterAccess VIP
Posts: 4,307
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.
Go to the top of the page
 
+
Nyteshade
post Aug 14 2006, 11:42 AM
Post #3

UtterAccess Ruler
Posts: 1,289
From: Ohio, USA
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.
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 04:10 PM