p45cal
The change of format of the whole cell is elementary. Unfortunately Symbol
numerals look noticeably different from Arial or Times ones. It is a matter
of taste.
The record into InputBox would be no problem, too: the mnemonic <= or =
with the following conversion in the macro would do the job.
Lets wait for UNICODE that I still have no experience with.
Thank you for your voice.
--
Petr Bezucha
"p45cal" wrote:
The difficulty being setting the font of the custom format characters to
"Symbol", yes?
No I don't think it's possible.
A work round might be to add a line of the ilk:
Cell.Font.Name = "Symbol"
in the code, but you'd still need users to know how to enter these
characters - perhaps with a userform instead of the InputBox?
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=143742