Results 1 to 3 of 3

How to make cell value bold along with other data

Threaded View

vdongen How to make cell value bold... 10-04-2010, 07:34 AM
Jamesr571 Re: How to make cell value... 10-04-2010, 08:31 AM
Marcol Re: How to make cell value... 10-04-2010, 08:54 AM
  1. #1
    Forum Contributor
    Join Date
    10-01-2010
    Location
    Jakarta
    MS-Off Ver
    Excel 2003
    Posts
    101

    How to make cell value bold along with other data

    How to make only the first value bold (from D3) and the remaining normal when the values are populated in a merged cell range?

    Private Sub CmbInsert_Click()
    Set srng = Application.InputBox(prompt:= _
    "Select A Range", Type:=8)
    With srng
    .HorizontalAlignment = xlCenter
    .VerticalAlignment = xlCenter
    .MergeCells = True
    .Value = Range("D3").Value & Chr(10) & IIf(TglbDriver.Value = True, "D", " ") & " " & Range("H3").Value & " " & IIf(TglbBeamer.Value = True, "B", " ")
    End With
    End Sub
    Last edited by vdongen; 10-04-2010 at 11:56 PM.

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