Share via

Display Unicode Characters

Anonymous
2012-06-24T14:58:52+00:00

I have some unicode characters in a cell.  Is there any easy way to have a macro get the cell contents and display the material in some kind of textbox or other userform in the same font as it appears in the cell?

A MsgBox doesn't do it.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-06-24T15:18:15+00:00

I have some unicode characters in a cell.  Is there any easy way to have a macro get the cell contents and display the material in some kind of textbox or other userform in the same font as it appears in the cell?

A MsgBox doesn't do it.

A user form with a label and the following code will display the content of the active cell when the user form is activated.

Private Sub UserForm_Activate()

   Label1.Caption = ActiveCell.Value

   Label1.Font.Name = ActiveCell.Font.Name

End Sub

Hope this helps / Lars-Åke

Was this answer helpful?

0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-06-24T16:14:41+00:00

    Thanks!

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2012-06-24T15:38:17+00:00

    It looks like Lars-Åke has posted the solution.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-06-24T15:12:27+00:00

    A single font:

    Arial Unicode MS

    Was this answer helpful?

    0 comments
  4. HansV 462.6K Reputation points
    2012-06-24T15:03:19+00:00

    Does the cell use a single font, or have you applied a different font to individual characters in the cell?

    Was this answer helpful?

    0 comments