Results 1 to 11 of 11

VBA - Add Font Bold

Threaded View

Redd VBA - Add Font Bold 12-15-2007, 05:30 AM
royUK Please read the Forum Rules &... 12-15-2007, 05:36 AM
VBA Noob Redd, Please read forum... 12-15-2007, 05:49 AM
Redd Where does the Bold code fit... 12-15-2007, 06:00 AM
Redd VBA interest = bold font 12-15-2007, 06:58 AM
VBA Noob Ignoring the rules won't help... 12-15-2007, 07:15 AM
Redd Vba Every other row shade 12-15-2007, 03:19 PM
royUK You don't need VBA to do... 12-15-2007, 03:28 PM
Redd Cond. Format used up 12-15-2007, 03:30 PM
VBA Noob Please read forum rules below... 12-15-2007, 03:48 PM
royUK Place this in the Worksheet... 12-15-2007, 03:57 PM
  1. #1
    Registered User
    Join Date
    12-15-2007
    Posts
    30

    VBA - Add Font Bold

    Private Sub Worksheet_Change(ByVal Target As Range)
    With Target
    If .Count > 1 Then Exit Sub
    If .Column = 3 Then
    If .Value = "m/c interest" Then
    .Offset(, 2).Value = Range("L2").Value
    ElseIf .Value = "interest" Then
    .Offset(, 2).Value = Range("L3").Value
    .Offset(, -1).Value = DateSerial(Year(Now), Month(Now) + 1, 0)
    ElseIf .Value = "web internet" Then
    .Offset(, 2).Value = Range("L4").Value
    ElseIf .Value = "cell phone" Then
    .Offset(, 2).Value = Range("N2").Value
    End If
    ElseIf .Column = 5 Then
    .Offset(, -3).Value = Date
    ActiveSheet.Unprotect "r"
    Target.Locked = True
    ActiveSheet.Protect "r"
    End If
    End With
    End Sub
    this part of code font bold
    .Offset(, -1).Value = DateSerial(Year(Now), Month(Now) + 1, 0)
    Thanks
    Last edited by VBA Noob; 12-15-2007 at 05:36 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1