Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indent based on Entry
I'm entering either 'no' or 'yes' in column D. If I enter 'yes' I would like
that text to automatically indent by 1 space (.IndentLevel = 1) so that it sticks out to me. Please help me you Gods of Excel. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indent based on Entry
Put the following event code in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range) Set r = Range("D:D") Set t = Target If Intersect(t, r) Is Nothing Then Exit Sub If t.Value = "yes" Then t.InsertIndent 1 End If End Sub -- Gary''s Student - gsnu200804 "JSnow" wrote: I'm entering either 'no' or 'yes' in column D. If I enter 'yes' I would like that text to automatically indent by 1 space (.IndentLevel = 1) so that it sticks out to me. Please help me you Gods of Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
Fill a cell based on last entry | Excel Discussion (Misc queries) | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
cell value based on combo box entry | Excel Worksheet Functions | |||
Formula based on a cell entry | Excel Discussion (Misc queries) |