Superscript Vba

May 19, 2009

I have a scheduling spreadsheet that I designed for excel. It uses numbers as text and vlookup values instead of calculating actual time (its easier and saves space). I want it to look aesthetically pleasing:

630-230 (that is six-thirty until two-thirty)
7-315 (that is 7 o'clock until three-fifteen)

should look like this:

630- 230
7 - 315

How should the code be written so that if I write a string of text "xxx-xxx or x-xxx" the right parts get superscripted automatically.

notice that the first example has 3 digits before the hyphen and the second example has 1 digit before the hyphen. I need the vba code to work no matter which example is used.

View 9 Replies


ADVERTISEMENT

How To Get Superscript Into The Custom Box

Mar 18, 2013

When using format cells > number >custom I want to custom oC with the degree symbol in superscript. how to get superscript into the custom box? Also where is the superscript icon for the quick access toolbar in Excel?

View 3 Replies View Related

Get Rid Of Superscript In Text

Jan 22, 2010

I have an amount of text in my spreadsheet, which contains superscript numbers and I want to get rid of these numbers.
Is it possible to do this with a UDF or a macro?

I include a simple example spreadsheet with the situation as it is, and how I would have it.

View 2 Replies View Related

Get Correct Output Of Superscript?

Jul 17, 2014

I want to superscript the text with red color. But now only a active cell is change to superscript with red color after running the macro.

View 2 Replies View Related

Superscript Formatting In Macros

Jul 25, 2006

I have a cell (A1) that, depending on a choice made elsewhere in the workbook, will return A2, A3, A4, or A5, which are all formatted differently with superscripts. How do I get that formatting to copy over to A1 without having to manually copy and paste format from the appropriate cell? I have to do this for a range of cells (A1:A15) instead of simply one.

View 4 Replies View Related

Superscript Font In Userform

Jun 19, 2007

Is there anyway to superscript font in userform such cm2 (you know what I mean) instead of cm^2.

View 8 Replies View Related

Text To Column Separated By Any Superscript

Jul 23, 2013

Text to column function. My database includes dates and names of medications separated with superscript numbers. The numbers are not fixed. So I need a separation between any superscript figures.

Example:

³4002/60/61³51³4002/50/11³gm³bat gm52 nanizon³מרוסק³ ³³006³4002/50/60³gm³stelbaT gm02 livomiS³³ ³³01³

The data is in reverse order but this was solved already.

View 1 Replies View Related

Superscript Subscript - Part Of A Cell - Using VBA

Apr 22, 2002

Is there a way to superscript or subscript only part of a cell's text? The forum below provides VBA to superscript an entire cell.

How about just part of a cell?

e.g. Say I type "The volume of the cylinder is 42 m3", the press the arrow key once (to have the cursor before 3, hold down shift, go forward to select 3. NOW, I want to run a macro or script to superscript the selected part of the text, in this case the 3.

http://www.mrexcel.com/board/viewtop...ic=856&forum=2

How about using an inputbox to choose part of the cell?


Or using an inputbox to ask you to choose the cell,
THEN counts number of characters,
THEN asks you where to start and stop the supercript or subscript,
THEN asked if you want to superscript or subscript
THEN asks if you want to superscript/subscript (depending on what was choosen) "selectect text"(have excel store the text part selected for formatting),
THEN carries it out?

Is this possible? I don’t know enough VBA to know.

Here's some code to get people started..

Range("A1").Select
ActiveCell.FormulaR1C1 = "m3" .........

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved