Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Cell Not Number Than Specific Word?
How do I write a procedure that would make the cell value the word "Studio"
if it is not a number (1 or 2 or 3 or 4 or 5)? It would be in the page's Selection_Change because the cell can be written to from another form also. Thank you in advance. Jim Kobzeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Cell Not Number Than Specific Word?
Are you sure you want it in the SelectionChange event? It seems
that the Change event would be more appropriate. Private Sub Worksheet_Change(ByVal Target As Range) If IsNumeric(Target.Text) = False Then Application.EnableEvents = False Target.Value = "Studio" Application.EnableEvents = True End If End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JK" wrote in message news:uzx8e.35301$qO6.3052@trnddc05... How do I write a procedure that would make the cell value the word "Studio" if it is not a number (1 or 2 or 3 or 4 or 5)? It would be in the page's Selection_Change because the cell can be written to from another form also. Thank you in advance. Jim Kobzeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of times a specific word appears in a single cell | Excel Discussion (Misc queries) | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
Linking a Specific Word to a Specific Number | Excel Worksheet Functions |