Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format Validation Cells
I have search the archives and have not found and answer to this simple
question! I have used Debra's site (http://www.contextures.com/xlDataVal01.html) to create a simple drop down menu in a cell using Data Validation. How do I then change the appearance of the cell and the drop down menu....for example increase the number of entries shown when you click on the arrow, or move the arrow to within the cell boundary, or give the cell a menu border.....ie. change the format of the cell without using FormatCell. Im sure I have used 'Format Control' before, but this is not available in the format menu? Any help will be greatly appreciated.... I am on Win Xp with Office 2002 SP3. John |
#2
|
|||
|
|||
The data validation dropdown is limited to 8 rows, and can't be changed,
nor can its font or font size be changed. If you can use macros, there's a sample file here that provides a combobox from which you can select one of the values. In a combobox, you can set the number of rows in the dropdown list: http://www.contextures.com/excelfiles.html Under 'Data Validation', look for 'Data Validation Combobox' John B wrote: I have search the archives and have not found and answer to this simple question! I have used Debra's site (http://www.contextures.com/xlDataVal01.html) to create a simple drop down menu in a cell using Data Validation. How do I then change the appearance of the cell and the drop down menu....for example increase the number of entries shown when you click on the arrow, or move the arrow to within the cell boundary, or give the cell a menu border.....ie. change the format of the cell without using FormatCell. Im sure I have used 'Format Control' before, but this is not available in the format menu? Any help will be greatly appreciated.... I am on Win Xp with Office 2002 SP3. John -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Format cells as date | Excel Discussion (Misc queries) | |||
Custom Format and Data Validation Q | Excel Worksheet Functions | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |