How do I set font on listbox in excel vba

Question

help me Private Sub UserForm_Initialize() Call filldata ListBox1.Font = 'Zawgyi-One' End Sub

Sunny Sharma · Answer

Hi ye htut, Please find the solution in attached worksheet. Happy Coding :)

Sunny Sharma · Answer

Hi, I understand that you're trying to add data in ListBox dynamically but I'm not clear on this point-" there are so many data under A1:D1 ". I suggest you catch me on FB: https://www.facebook.com/Sunnydelhi You'll be able to attach files here and I can see them.

Ye Htut · Answer

the attached file of you is static on cell range. I want to get dynamic that means there are so many data under A1:D1. I wanna state all data. how do I repair your code. I have done with for looping. But it has errors. Plz help me. Thz :)

Sunny Sharma · Answer

I'm not sure about why I'm not being able to download this attachment, did you check the sample worksheet attached in my previous reply? I'm still getting the same response-"page not found" while trying to download the attachment :(

Ye Htut · Answer

Plz check again thz

Sunny Sharma · Answer

Don't know why, not able to download your file-it shows "page not found". I've attached a sample worksheet with List box Modification sample, check that. Hope it helps :)

Ye Htut · Answer

and Can set up unicode fonts on listbox in excel vba?

Sunny Sharma · Answer

please check and re-attach, no file is uploaded.

Ye Htut · Answer

Now, I had uploaded

Sunny Sharma · Answer

just zip your file and upload in your reply. See the image below:

Ye Htut · Answer

how can I attach my file to u

Sunny Sharma · Answer

can you share your worksheet you're having problem with?

Ye Htut · Answer

I also have change font name in property but that font doesn't appear in listbox.

Sunny Sharma · Answer

Hi ye htut, You can just use the Properties of List Box. Select the List Box, Hit F4 (shortcut to bring up Properties box), Select the Font property and click ellipsis in right. Modify the font as desired. Simple as that.

How do I set font on listbox in excel vba

Answers (14)