| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting
I'd like to format a cell (C15 for example), so that whenever I enter a name
(e.g. "John Smith"), it is automatically converted to "Mr. John Smith". How can I do that in Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formatting
You can do that with this event sub, but what about women?
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "C15" Then Application.EnableEvents = False Target.Value = "Mr. " & Target.Value Application.EnableEvents = True End If End Sub Regards, Stefi €˛Hi_no_Tori€¯ ezt Ć*rta: I'd like to format a cell (C15 for example), so that whenever I enter a name (e.g. "John Smith"), it is automatically converted to "Mr. John Smith". How can I do that in Excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formatting
Thanks a lot Stefi. I tried the code and its working. As for women. There
are no women, so the code should be o.k. Thanks again Stefi. (^_^) "Stefi" wrote: You can do that with this event sub, but what about women? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "C15" Then Application.EnableEvents = False Target.Value = "Mr. " & Target.Value Application.EnableEvents = True End If End Sub Regards, Stefi €˛Hi_no_Tori€¯ ezt Ć*rta: I'd like to format a cell (C15 for example), so that whenever I enter a name (e.g. "John Smith"), it is automatically converted to "Mr. John Smith". How can I do that in Excel? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formatting
You are welcome! Thanks for the feedback!
Stefi €˛Hi_no_Tori€¯ ezt Ć*rta: Thanks a lot Stefi. I tried the code and its working. As for women. There are no women, so the code should be o.k. Thanks again Stefi. (^_^) "Stefi" wrote: You can do that with this event sub, but what about women? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "C15" Then Application.EnableEvents = False Target.Value = "Mr. " & Target.Value Application.EnableEvents = True End If End Sub Regards, Stefi €˛Hi_no_Tori€¯ ezt Ć*rta: I'd like to format a cell (C15 for example), so that whenever I enter a name (e.g. "John Smith"), it is automatically converted to "Mr. John Smith". How can I do that in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
| Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
Linear Mode
