ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo Box loaded with Excel Number Formats (https://www.excelbanter.com/excel-programming/325275-combo-box-loaded-excel-number-formats.html)

ExcelMonkey[_190_]

Combo Box loaded with Excel Number Formats
 
Does anyone know how to pull the number formats in Excel
into a combo box? I know how to load the fonts from
Excel into a combobox:

Set FontList = Application.CommandBars
("Formatting").FindControl(ID:=1728)
For N = 0 To FontList.ListCount - 1
With UserForm1.FontTypeCmbBx
.AddItem FontList.List(N + 1)
End With
Next N

However when I try the following using ID:855 I get a
object doesn't support this method or property. Is there
a way to do this.

Set NumberFormat = Application.CommandBars
("Standard").FindControl(ID:=855)
For N = 0 To NumberFormat.ListCount - 1
With UserForm1.NumFormatTypeCmbBx
.AddItem NumberFormat.List(N + 1)
End With
Next N


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com