Negative number morphing to a cell code
As coded this only works on cell B9. Even though it look complicated, its not:
1. right-click the tab name at the bottom of Excel
2. select View Code
this open a VBA window
3. paste my stuff in
4. close the VBA window
play around with entering positive and negative values in B9.
If you are nervious about VBA, just try it out on a fresh new workbook first.
--
Gary''s Student - gsnu200747
"nickra" wrote:
On Sep 24, 7:28 pm, Gary''s Student
wrote:
Sorry - use this version instead:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B9")) Is Nothing Then Exit Sub
If Target.Value 0 Then Exit Sub
v = -Target.Value & "+"
Application.EnableEvents = False
Target.Value = v & Target.Address(RowAbsolute:=False, ColumnAbsolute:=False)
Application.EnableEvents = True
End Sub
--
Gary''s Student - gsnu200746
"nickra" wrote:
I know this is probably an easy one, but I can't find the right
button. Every time I type, say, -3, into a cell, it turns into -3 and
then adds the cell wherever my cursor is, like L11. So, I get 3+L11 in
the cell instead of -3. What do I need to do? It's gotta be simple, I
know.
Huh? I have no clue what you are talking about. Is there a simple
button to click to change this or something. Ic an't believe something
as simple as typing in a negative number would cause such a glitch.
|