Avatar of Svgmassive
Svgmassive

asked on 

Font dialog 64bit fot excel

I am looking for a working 64bit Font dialog for Excel.
THanks
Microsoft AccessMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Roy Cox
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Do you mean something like this

 
Application.Dialogs(xlDialogFont).Show

Open in new window

Avatar of Svgmassive
Svgmassive

ASKER

Not eaxctly.. looking for something that uses FormFontInfo
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

I'm not really sure what you want, here's an alternative dialog

Application.Dialogs(xlDialogFontProperties).Show

Open in new window

Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

FormFontInfo appears to be for MS Access, not applicable to Excel as far as I know.
Avatar of Svgmassive
Svgmassive

ASKER

it   works in 32bit excel
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Cam you attach a workbook with the code that you are using so that I can see what needs changing
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Svgmassive
Svgmassive

ASKER

Any more ideas.The 64bit is still not functions
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

I'm still waiting to see an example that works in 32 Bit.

I looked at it in Access and the example I found didn't due much. I'm not sure what you want to do with it.
Avatar of Svgmassive
Svgmassive

ASKER

this work in excel 32 bit
fonts.xlsb
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

All that code seems to simply do what my earlier suggestion does from running your test codes

Application.Dialogs(xlDialogFontProperties).Show

Open in new window


I still don't know what you want to achieve,
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo