Display items in their own fonts inside the combobox????

Hello! There

I need help from you guys. I have created a combo box which act as command bar using VBA code. The problem is that I need to display the items inside the combo box in their respective fonts instead of English. Other fonts are already installed in my system.
Thanks at the earliest.
trojanhackerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bhagyeshtCommented:
if u can easily do it using the control tools, goto show toolbar, then select the control toolbox, then add a combobox, once added right click on it and set the font. thats it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JoaTexCommented:
Hi
 In this litlle example put the language in combo1 and combo2 will show font of selected language.

put 2 combobox in a form.

code:

Option Explicit
Dim test(3) As String
Dim Estil(3) As String
Dim N
Private Sub Combo1_Click()
   Combo2.Clear
   Combo2.FontName = Combo1.List(Combo1.ListIndex)
      For N = 0 To 2
         Combo2.AddItem test(N)
      Next N
   Combo2.Text = "Test"
End Sub

Private Sub Form_Load()
   For N = 0 To 2
      test(N) = "Test" & N + 1
      Select Case N
         Case Is = 0
            Estil(N) = "Arial Black"
         Case Is = 1
            Estil(N) = "Times New Roman"
         Case Is = 2
            Estil(N) = "Ms Serif"
      End Select
      Combo1.AddItem Estil(N)
   Next N
End Sub

hope it suites you
Jo
0
CleanupPingCommented:
trojanhacker:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.