Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interface Design: Drop Down
I am working on a workbook that contains drop-downs in various cells. The source for these drop downs are several Named Ranges on a tab name 'Drop Downs'. I am locking the whole spreadsheet down so that people are not messin with the format, etc. (which is the current problem). So I don't allo people to add/delete rows, etc. I am trying to think of a good interface to allow users to modify th entries in each drop down list (i.e. they may need to add a person t the "Resources" Range which feeds into a drop-down box elsewhere). So, people should be able to add/delete items. I was thinking I woul put a little 'X' next to each entry, such that when pressed - it woul delete the corresponding entry. (Using the Assign Macro on a Tex Box). However, I have to assign each 'X' a method to call - and can't pass in an argument - so if I assign them all the same macro nam - I won't be able to figure out which one was pushed. And the number o 'X' will be dynamic, so I can't hard code a bunch of functions. I don' really have a good idea for allowing additions yet (other than a butto that prompts for the name and then adds it in). I guess I could just use a Form that allows editing of the data (tha would be easy and powerful to do), but I don't really want to do that I want it to be editable within the excel spreadsheet itself. ANY IDEAS FOR GOOD LAYOUTS THAT YOU HAVE USED TO ALLOW USERS TO MODIF LISTS Thanks -- whitehurs ----------------------------------------------------------------------- whitehurst's Profile: http://www.excelforum.com/member.php...fo&userid=3454 View this thread: http://www.excelforum.com/showthread.php?threadid=54810 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB interface | Excel Programming | |||
Hyperlinks Inserted in Design Mode inactive once Exited Design Mod | Excel Programming | |||
QUI Expert: Excel-based User Interface or OO User Interface? | Excel Programming | |||
GUI Expert: Excel-based User Interface or OO User Interface? | Excel Programming | |||
Enter Excel Design Mode and Exit Design Mode | Excel Programming |