How to I make text Bold in a User Form -Visual Basic

gurp99 · #1 03-08-2012, 03:07 PM

Hello,

I have created a Macro enabled template with User form that automatically opens when the document is opened. One of the issues I am having is trying to figure out how to have the text in a field come out to the document in Bold format.

Does anyone know how to do this? I have attached a screenshot

Thanks

macropod · #2 03-09-2012, 05:05 PM

Hi gurp,

If you want the text on the userform to appear bold, set the font attribute for that element to bold. For example:
TextBox1.Font.Bold = True

If you want the output in the document to be bolded, set a range object to the destination, populate the range, then format the range as bold. For example:

Code:

Dim Rng As Range
Set Rng = ActiveDocument.Bookmarks("SomeBookmark").Range
With Rng
  .Text = TextBox1.Text
  .Font.Bold = True
End With
ActiveDocument.Bookmarks.Add "SomeBookmark", Rng

gurp99 · #3 03-12-2012, 01:58 PM

This is the error i get
what am i doing wrong?

macropod · #4 03-12-2012, 02:25 PM

That doesn't show an error, which would be indicated by yellow highlighting and an error message, but a breakpoint.

gurp99 · #5 03-12-2012, 02:29 PM

picture attached

macropod · #6 03-12-2012, 02:51 PM

And what is the error message you're getting?

gurp99 · #7 03-12-2012, 02:59 PM

Run-Time error '424

Object required

macropod · #8 03-12-2012, 03:35 PM

I am unable to replicate that error with the kind of code I gave you. See attached. It would seem there is something somewhere else in your project that is having an adverse effect.

gurp99 · #9 03-12-2012, 03:39 PM

I am a novice user to VBA. With the code you supplied, what needs to be changed? just the text in red?

Dim Rng As Range
Set Rng = ActiveDocument.Bookmarks("SomeBookmark").Range
With Rng
.Text = TextBox1.Text
.Font.Bold = True
End With
ActiveDocument.Bookmarks.Add "SomeBookmark", Rng

gurp99 · #10 03-12-2012, 03:57 PM

Here is the link to the file:

macropod · #11 03-12-2012, 03:58 PM

From looking at your images, you'd also have to change the 'textbox1' reference. The first one had that change, but for some reason you undid that change before posting the second image.

gurp99 · #12 03-12-2012, 04:05 PM

SOLVED

I got it to work...

Thank you very much for the help Paul.

Much obliged

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Visual Basic error - run time error 504	crazymorton	Word	11	01-13-2012 04:32 AM
Visual Basic Editor changes from 2003 to 2007	Rockitman31	Word VBA	4	09-21-2011 12:01 PM
Basic user needs drop down menus	Mabozar	Word	1	01-19-2010 02:49 PM
Referencing Tables in Visual Basic Editor	DavidB	Word Tables	0	09-21-2009 04:01 PM
A little Visual Basic Help Please	leroytrolley	Excel	4	08-22-2008 03:57 AM