Results 1 to 11 of 11

VBA - Add Font Bold

Threaded View

  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