How do i make certain words automatically bold themselves.
I need certain words in my scedules to be bold. I dont want to have to go
through all my charts and select these individual words & i would like to have these specific words just become bold as i type them in the future. Please help. |
How do i make certain words automatically bold themselves.
right click sheet tabview codecopy/paste this. I commented out other
examples Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub 'Target.Offset(, -1) = Target.Row 'If Target 4 Then Target.Borders.Weight = xlThick ''If Target = "jj" Then Target.Font.Bold = True Select Case Target Case "jj", "kk", "ll" : Target.Font.Bold = True End Select End Sub -- Don Guillett SalesAid Software "INFO@Skyline" wrote in message ... I need certain words in my scedules to be bold. I dont want to have to go through all my charts and select these individual words & i would like to have these specific words just become bold as i type them in the future. Please help. |
How do i make certain words automatically bold themselves.
Are these words by themselves in a cell or part of other text in a cell?
Which words do you want bolded? Are they located in any particular range? Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 08:10:02 -0800, INFO@Skyline wrote: I need certain words in my scedules to be bold. I dont want to have to go through all my charts and select these individual words & i would like to have these specific words just become bold as i type them in the future. Please help. |
How do i make certain words automatically bold themselves.
Gordon,
for example: Stainless Steel Wall Mounted Handrail at Auditorium all of the above is in a single cell together. only stainless steel would need to be in bold. they are in column B which is labeled description with no codes. "Gord Dibben" wrote: Are these words by themselves in a cell or part of other text in a cell? Which words do you want bolded? Are they located in any particular range? Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 08:10:02 -0800, INFO@Skyline wrote: I need certain words in my scedules to be bold. I dont want to have to go through all my charts and select these individual words & i would like to have these specific words just become bold as i type them in the future. Please help. |
How do i make certain words automatically bold themselves.
this makes absolutly no sence to me.
"Don Guillett" wrote: right click sheet tabview codecopy/paste this. I commented out other examples Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 2 Then Exit Sub 'Target.Offset(, -1) = Target.Row 'If Target 4 Then Target.Borders.Weight = xlThick ''If Target = "jj" Then Target.Font.Bold = True Select Case Target Case "jj", "kk", "ll" : Target.Font.Bold = True End Select End Sub -- Don Guillett SalesAid Software "INFO@Skyline" wrote in message ... I need certain words in my scedules to be bold. I dont want to have to go through all my charts and select these individual words & i would like to have these specific words just become bold as i type them in the future. Please help. |
How do i make certain words automatically bold themselves.
Sub boldselectedword()
myword = "bbb" fc = InStr(activecell, myword) lc = Len(myword) ActiveCell.Characters(fc, lc).Font.Bold = True End Sub -- Don Guillett SalesAid Software "INFO@Skyline" wrote in message ... Gordon, for example: Stainless Steel Wall Mounted Handrail at Auditorium all of the above is in a single cell together. only stainless steel would need to be in bold. they are in column B which is labeled description with no codes. "Gord Dibben" wrote: Are these words by themselves in a cell or part of other text in a cell? Which words do you want bolded? Are they located in any particular range? Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 08:10:02 -0800, INFO@Skyline wrote: I need certain words in my scedules to be bold. I dont want to have to go through all my charts and select these individual words & i would like to have these specific words just become bold as i type them in the future. Please help. |
All times are GMT +1. The time now is 12:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com