Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 9th 05, 03:02 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2005
Posts: 172
Default 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   Report Post  
Old March 9th 05, 03:50 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to increase font size of dropdown list prabal Excel Discussion (Misc queries) 3 April 15th 08 02:21 AM
Changing Font color based on font type or size John Excel Discussion (Misc queries) 2 February 7th 08 12:50 AM
Dropdown Font Size Bob Barnes Excel Discussion (Misc queries) 3 January 5th 06 12:53 AM
Font size in a dropdown list Ant Excel Discussion (Misc queries) 3 November 3rd 05 02:21 PM
how to increase the font size in a dropdown list? Sossys Excel Worksheet Functions 2 December 16th 04 01:09 PM


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017