How do I upshift text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have a series of cells that, when I enter text, it is upshifted
 
Select your range, Format>Cells>Alignment>Vertical>Top

Carlos
 
Assuming the Range is A1:A20 then

Right Click the Sheet Tab and select "View Code"

Paste the following into the code window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim MyCell As Range, MyRange As Range
Set MyRange = Me.Range("A1:A20")
For Each MyCell In MyRange
MyCell = UCase(MyCell)
Next
End Sub

Select File ....Close and return to Excel
 
Lots of different answers. Each is correct depending on the interpretation
of the question.
Can we hear from the OP? What was the question?
 
Upshift.....Superscript??

Gord Dibben Excel MVP

Lots of different answers. Each is correct depending on the interpretation
of the question.
Can we hear from the OP? What was the question?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking for A particular type of Video card 8
upcase textbox input? 6
Series fill only copying and fill series greyed out 1
Entering a Text Symbol ? 2
Excel 2000 export loses long text 1
Excel 2007: Word wrapping in merged cells 2
Excel Typed text appears in wrong cell 0
# sign appearing in text boxes, Why? 4

Back
Top