1

I'm trying to print the lambda (λ) character using following code:

depug.print chr(964)

I looked up the specific value for lambda for the chr-function here. Unfortunately I get a Runtime-Error 5 with the information that it is an invalid value.

I found out this seems to appear using values over 255.

Now I am curious, how to print that lambda character? Respectively any other greek character?

Darren Bartrup-Cook
  • 18,362
  • 1
  • 23
  • 45
J.schmidt
  • 721
  • 5
  • 27

1 Answers1

5

You should be able to use 

 ActiveCell.Value = ChrW(&H3BB)

credit: https://www.w3.org/Math/characters/html/symbol.html just replace 00 with &H

This thread also shows a link to a unicode converter Special characters(letters) in excel VBA (čćžšđ)

ShanayL
  • 1,217
  • 2
  • 14
  • 29
  • I tried that code and got a "?"... Does it depend which Excel-version I am using (2016) – J.schmidt Dec 21 '18 at 13:43
  • 2
    I dont think you can print it in the "immediate" window... i updated my answer to just displaying it in the excel sheet – ShanayL Dec 21 '18 at 13:45