Using Outlook controls in Excel VBA

Question

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

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

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

i like the the ui of the textbox, buttons, checkbox control and etc. so do you think sending mail is my purpose? — xander36
– xander36, Commented Mar 24, 2021 at 6:29
@SiddharthRout thank you for the question. compare 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) — xander36
– xander36, Commented Mar 24, 2021 at 6:47
Yes you will not be able to use them on VBE Userforms. No question is stupid. As per me, there are 2 types of questions (You may disagree). Good questions and Vague questions. Unfortunately, your question in the current format falls under "Vague questions" and hence I guess it is being downvoted and may get closed soon. Like I mentioned above, update your question. Explain exactly what you are trying to achieve and what problems are you currently facing (For example that error message) ;) — Siddharth Rout
– Siddharth Rout, Commented Mar 24, 2021 at 7:11
See I updated your question. Now tell me... Does it make more sense to readers as to what you are trying to achieve? :) — Siddharth Rout
– Siddharth Rout, Commented Mar 24, 2021 at 7:15

Siddharth Rout · Accepted Answer · 2021-03-24 07:23:05Z

4

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.

edited Mar 24, 2021 at 7:23

answered Mar 24, 2021 at 7:19

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

xander36 Over a year ago

noted on this. thank you once again for the help

Collectives™ on Stack Overflow

Using Outlook controls in Excel VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related