Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown list for font size, font type and number formats
I have a userform which I want to put three combo box
controls onto. I want to be able to display: 1) All the font sizes currently in the file 2) All the font types currently in the file 3) All the number formats currently in the file Is the only way to do this involve looping through each sheet and cell and loading them into an array and make adustments for redundant entries? Or is there a faster way to do this through some sort of API call? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown list for font size, font type and number formats
Looping. To the best of my knowledge.
-- Regards, Tom Ogilvy "ExcelMonkey" wrote in message ... I have a userform which I want to put three combo box controls onto. I want to be able to display: 1) All the font sizes currently in the file 2) All the font types currently in the file 3) All the number formats currently in the file Is the only way to do this involve looping through each sheet and cell and loading them into an array and make adustments for redundant entries? Or is there a faster way to do this through some sort of API call? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to increase font size of dropdown list | Excel Discussion (Misc queries) | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Dropdown Font Size | Excel Discussion (Misc queries) | |||
Font size in a dropdown list | Excel Discussion (Misc queries) | |||
how to increase the font size in a dropdown list? | Excel Worksheet Functions |