I'm wondering when a user makes their selection via option button in a user form, is it possible to have it populate text that has multiple formatting properties (need a bullet & bold font). For example, I would like the end result from the user's selection to be appear as follows: HEADING: I need my result to populate as it appears here with the bullet and the heading title in bold font. Of course the all caps portion and remaining text is standard, it's the bullet and bold font of the heading I'm wondering about. Private Sub cmdOK_Click() Dim Direction As String If East = True Then Direction = "formatted text here" If West = True Then Direction = "formatted text here" Hopefully that makes sense. Not sure this is possible, but I've been surprised before.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Option Button in Userform Populates "formatted" Text

Thread starter Gordo24
Start date Oct 15, 2011
Tags

userform vba

Gordo24

New Member

Oct 15, 2011

I'm wondering when a user makes their selection via option button in a user form, is it possible to have it populate text that has multiple formatting properties (need a bullet & bold font). For example, I would like the end result from the user's selection to be appear as follows:

HEADING: I need my result to populate as it appears here with the bullet and the heading title in bold font.

Of course the all caps portion and remaining text is standard, it's the bullet and bold font of the heading I'm wondering about.

Private Sub cmdOK_Click()
Dim Direction As String
If East = True Then Direction = "formatted text here"
If West = True Then Direction = "formatted text here"

Hopefully that makes sense. Not sure this is possible, but I've been surprised before.