I
IJO
I want to have a series of cells that, when I enter text, it is upshifted
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
upshifted???
C
CarlosAntenna
Select your range, Format>Cells>Alignment>Vertical>Top
Carlos
Carlos
A
Andy Pope
H
Hayeso
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
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
C
CarlosAntenna
Lots of different answers. Each is correct depending on the interpretation
of the question.
Can we hear from the OP? What was the question?
of the question.
Can we hear from the OP? What was the question?
G
Gord Dibben
Upshift.....Superscript??
Gord Dibben Excel MVP
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?