I'm working with the richText control on a vba form. Essentially I want to
recreate the formatting command bar on my form so that I can use the bold,
italic, underline and font colour buttons as they normally appear in excel.

Can anyone help me to remake this command bar on a form?

- Rm

Can't give you the whole solution, but maybe a start.

Create toggle buttons (one for bold, italics, underline) and one drop down
(for font color)
Make them look as much like the toolbar as you can and place code in each
change event to toggle the fonts.



"Robert Mulroney" wrote:


I'm working with the richText control on a vba form. Essentially I want to
recreate the formatting command bar on my form so that I can use the bold,
italic, underline and font colour buttons as they normally appear in excel.

Can anyone help me to remake this command bar on a form?

- Rm

Thanks, that actually what I ended up doing. I've used the ImageCombo box to
recreate the font select combo. I just screen dumbed an image of what the
options in excels font select look like and slotted the image into an
imagecombo. It's not a perfect solution becase if I want to add a new font I
have to create a new image each time. It does look pretty good though.

- Rm


"JNW" wrote:

Can't give you the whole solution, but maybe a start.

Create toggle buttons (one for bold, italics, underline) and one drop down
(for font color)
Make them look as much like the toolbar as you can and place code in each
change event to toggle the fonts.



"Robert Mulroney" wrote:


I'm working with the richText control on a vba form. Essentially I want to
recreate the formatting command bar on my form so that I can use the bold,
italic, underline and font colour buttons as they normally appear in excel.

Can anyone help me to remake this command bar on a form?

- Rm