Changing Font Name in Function Sub

[Guest]

I wrote a Function Sub with alphbet letters as output, but wish to change
this output to greek symbols. These are my codes:

with activecell
.font.name="symbol"
end with

It doesnt work. Can anyone correct it for me? Many thanks.

 

[Guest]

The coding is OK to run on my PC.

Are you sure the user get the correct Symbol font?

Can it be manually changed? if yes, it should be OK.

 

[Guest]

Yes. It can be manually changed from the Font menu. But can't have the result
when embedded in the Function Sub.

 

[NickHK]

If you are trying to write a worksheet function to achieve this, it will
fail.
You can only return a value to a cell, not change the Excel environment.

NickHK

 

[Guest]

Thanks. I guess that must be the reason why I fail. Looks like I have to give
up that idea and change the font manually.

zhj23

 

[Guest]

Hi

I believe it works if you set it as macro or a Sub in VBA.

But worksheet function is not the correct way to do that.

 

[Guest]

OK. Thanks. I will try.

zhj23

Hi

I believe it works if you set it as macro or a Sub in VBA.

But worksheet function is not the correct way to do that.