Why do you need to prompt the user for this? Is their some reason why
the user can't just select these from the toolbar control?
Otherwise, you'd need to use the VB6 Common Dialog control, which would
have to be distributed with your VBA project. A VB6 developer license
is required to use/distribute the control in your projects.
Perhaps you can google to see if someone has written a pure VB font
picker that you can modify to work in a VBA userform. Or maybe there's
a DLL available!
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.