Thể loại
Loại hình
Tất cả

bangnam.com

Relaxed, inspiring essays about happiness.

10.7K

10

8

VBA listbox column text alignment

Hi All!,

This is my first question on this website.

Problem Description

The problem is that in VBA Excel ListBox, we cannot select each single column's separate text alignment. The default TextAlign property will align all columns to the chose alignment.

How we can solve this problem so that, for example, we can have 1 text column is aligned Left and 1 numbers column which needs to be aligned Right.

Thank you.

Regards

What I have tried:

I have tried various Excel forums but couldn't find a practical solution other that numbers padding and using courier font solution, which is quite unprofessional and misfortune give the fact we have astute and sharp programmers in this world.


Add your solution here

B I U S small BIG code var < > & link [^] encode untab case indent outdent

Preview 0

Existing Members

...or Join us

Download, Vote, Comment, Publish.

Your Email
This email is in use. Do you need your password?
Optional Password
When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
  4. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.
Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900

Dịch vụ SEO website - Thiết kế Website

★★★★★ 7 đánh giá trên Google
Văn phòng công ty

Địa chỉ: Số 5 Trần Kim Xuyến - P.Trung Hoà - Q.Cầu Giấy - TP. Hả Nội

Điện thoại: 0922 892 892

Trang web: Bangnam.com

Từ Dịch vụ SEO website - Thiết kế Website

"BANGNAM là đơn vị cung cấp Dịch Vụ SEO, Dịch vụ thiết kế Website, Giải pháp quản trị doanh nghiệp ERP hàng đầu tại Việt Nam."

Mọi người cũng tìm kiếm

Thiết kế website Hà Nội
Nhà thiết kế trang web
Thiết kế website bán hàng
Nhà thiết kế trang web
Dịch vụ SEO
Nhà tối ưu công cụ tìm kiếm
Thiết kế website TP HCM
Nhà thiết kế trang web
Thiết kế website Hà Nội
Nhà thiết kế trang web