CODEWITHSUNDEEP
excelvbaoutlook
xander36
xander36

Reputation: 79

Using Outlook controls in Excel VBA

Objective: When compared, I feel the looks of outlook control is better than the ordinary. So what I want to do is use the outlook controls like buttons, textbox instead of the ordinary one (builtin controls).

Problem: When I place the control on the VBE Userform, I get the System Error H80004005 (-2147467259). Unspecified error

enter image description here

Question: Is it possible to use ms outlook controls in excel vba?

These are the highlighted controls that I would like to use.

enter image description here

Upvotes: 1

Views: 575

Answers (1)

Siddharth Rout
Siddharth Rout

Reputation: 149277

If I am not wrong, unfortunately, you cannot add these controls to a VB UserForm object in the VBE.

You can only add these controls to a form region in outlook form using the forms designer.

Having said that, you should avoid using additional controls if you are planning to distribute your workbook because the other person may not have those controls installed. For example, lot of people use MS office without having MS Outlook installed.

Upvotes: 4

Related Questions