Cant add common dialog to userform

athertm

New Member
Joined
Feb 16, 2002
Messages
26
When I try to insert the MS Common Dialog control on to a userform I get the "Control cannot be added because it's not properly licenced"

My question is, do I need the developer edition of office to be able to use this?

If not what do I need.

If I get what I need will any forms that use the control work on other machines.

Hope that makes sense.

Oh yes...Office 2003, WINXP SP2.

Cheers.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
What do you want to do with the Common Dialog control?

When developing userforms for workbooks that may be distributed to other users you should try and stick to the standard controls.
 
Upvote 0
Ah ha!!

Maybe that is the problem. I'm currently working through a book "VBA programming and macros for excel" and it's used in one of the examples.

In fact the're stating the benefits of using the inbuilt MS dialogs to simplify the use of forms.

What should I use?
 
Upvote 0
The dialog would be used to select a colour from the format section to use in highlighting cells with formulas in them.

It's not really a question of highlighting the cells as I've managed to do that by just using a fixed value for the colour, it's more of an excercise in using the dialog in a userform.

If the advise is to use another type of control then I'm happy to listen.
 
Upvote 0
Are you sure the book was referring to the Common Dialog control?

It doesn't sound like it to me.

Try typing Dialogs in the VBE and pressing F1.

What is the help topic?:)
 
Upvote 0
Ok, I think i'm getting there.

Application.Dialogs(xlDialogColorPalette).Show

This brings up the pallete dialog which I could use to apply the selct color?

is this right?
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,913
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top