 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2007active cell bold
Im trying to make the active cell either bolded or highlighted. Is that possible? Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) With Cells.Font .FontStyle = "Regular" End With With ActiveCell.Font .FontStyle = "Bold" End With End Sub Vaya con Dios, Chuck, CABGx3 > Im trying to make the active cell either bolded or highlighted. Is that > possible? hi Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone With Cells.Font .FontStyle = "regular" End With ActiveCell.Interior.ColorIndex = 6 'yellow With ActiveCell.Font .FontStyle = "bold" End With End Sub regards FSt1 > Im trying to make the active cell either bolded or highlighted. Is that > possible? Can I have that a little slower so my small brain can take it in? Are these formulas added to the entire selection? Sorry. > hi > Private Sub Worksheet_SelectionChange(ByVal Target As Range) [quoted text clipped - 13 lines] > > Im trying to make the active cell either bolded or highlighted. Is that > > possible? They are not formulas, formulas cannot do this. You would need event macros Right click the sheet tab where you want this to happen and select view code. then paste in the code. Press Alt + q and save the workbook  SignatureRegards, Peo Sjoblom > Can I have that a little slower so my small brain can take it in? Are > these [quoted text clipped - 17 lines] >> > Im trying to make the active cell either bolded or highlighted. Is that >> > possible? Thats frickin awesome. Thanks a bunch. > They are not formulas, formulas cannot do this. You would need event macros > Right click the sheet tab where you want this to happen and select view [quoted text clipped - 21 lines] > >> > Im trying to make the active cell either bolded or highlighted. Is that > >> > possible? Just as long as you realize that this wipes out color formatting from every cell other than the active cell with no going back. Gord Dibben MS Excel MVP >Thats frickin awesome. Thanks a bunch. > [quoted text clipped - 23 lines] >> >> > Im trying to make the active cell either bolded or highlighted. Is that >> >> > possible? Right on Gord............that's why I stuck with just the "bolding" part in my response. Vaya con Dios, Chuck, CABGx3 > Just as long as you realize that this wipes out color formatting from every cell > other than the active cell with no going back. [quoted text clipped - 33 lines] > >> >> > Im trying to make the active cell either bolded or highlighted. Is that > >> >> > possible? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.