Cant add common dialog to userform

[athertm]

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.

 

[Norie]

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.

 

[athertm]

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?

 

[Norie]

What do you want to do?

 

[athertm]

ADVERTISEMENT

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.

 

[Norie]

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?

 

[athertm]

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?