Dropdown list for font size, font type and number formats

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List of Fonts 2
Can you change the font and font size for a forms control ? 4
Change font and/or font size in headers, footers and body via VBA 1
Validation Dropdown Font Size Change 11
Adjustable Font Size 6
Delete Rows as per Text, Font Color, Font Type, Time Format 11
change font using conditional formatting 1
Open file from path in cell and open from current file path 0

Back
Top