ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Position a string by the pixel unit (https://www.excelbanter.com/excel-programming/390163-position-string-pixel-unit.html)

clara

Position a string by the pixel unit
 
Hi all,

Is it possible to position or pad a string by the pixel unit? By now,
space() is base on character.

Clara
--
thank you so much for your help

Ben McBen

Position a string by the pixel unit
 
There are other monospaced fonts apart from courier!

"clara" wrote:

Hi all,

Is it possible to position or pad a string by the pixel unit? By now,
space() is base on character.

Clara
--
thank you so much for your help


JLGWhiz

Position a string by the pixel unit
 
For Excel, you can position almost, repeat, almost all shapes including
controls and word art by using pixels. When you refer to strings, I assume
you mean like text and non-numeric characters in cells or in dialog boxes,
list boxes, combo boxes, etc.
I believe you are stuck with ens and ems (space).
"clara" wrote:

Hi all,

Is it possible to position or pad a string by the pixel unit? By now,
space() is base on character.

Clara
--
thank you so much for your help


NickHK

Position a string by the pixel unit
 
It would depend somewhat on where/what you trying to achieve.
If within a cell, you are pretty limited on position, but formatting of
font/size etc can be done on each char, by using Characters.
You can use a label to position text anywhere, but then are limited to a
single font/format.

NickHK

"clara" wrote in message
...
Hi all,

Is it possible to position or pad a string by the pixel unit? By now,
space() is base on character.

Clara
--
thank you so much for your help





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

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