| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to embed a dialog in a Form?
I am currently using
Application.Dialogs(xlDialogEditColor).Show to show the built-in dialog colour picker. Is this available as a component that I can embed in a form? Would there be any licencing issues? Ed Ferrero Microsoft Excel MVP http://www.edferrero.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to embed a dialog in a Form?
It isn't a component. It also doesn't operate as a component, so you can
not query it for the users selection, even when called independently. It fuctions as if the menu item associated with it were picked. -- Regards, Tom Ogilvy "Ed Ferrero" wrote in message ... I am currently using Application.Dialogs(xlDialogEditColor).Show to show the built-in dialog colour picker. Is this available as a component that I can embed in a form? Would there be any licencing issues? Ed Ferrero Microsoft Excel MVP http://www.edferrero.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to embed a dialog in a Form?
Thanks Tom,
That's saved me from wasting time looking. I might just build my own colour wheel and be done with it. Ed It isn't a component. It also doesn't operate as a component, so you can not query it for the users selection, even when called independently. It fuctions as if the menu item associated with it were picked. -- Regards, Tom Ogilvy "Ed Ferrero" wrote in message ... I am currently using Application.Dialogs(xlDialogEditColor).Show to show the built-in dialog colour picker. Is this available as a component that I can embed in a form? Would there be any licencing issues? Ed Ferrero Microsoft Excel MVP http://www.edferrero.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to embed a dialog in a Form?
If you mean with a userform, John Walkenbach has one:
http://j-walk.com/ss/excel/tips/tip49.htm if you are using the API, the common dialog control has a color picker mode. -- Regards, Tom Ogilvy "Ed Ferrero" wrote in message ... Thanks Tom, That's saved me from wasting time looking. I might just build my own colour wheel and be done with it. Ed It isn't a component. It also doesn't operate as a component, so you can not query it for the users selection, even when called independently. It fuctions as if the menu item associated with it were picked. -- Regards, Tom Ogilvy "Ed Ferrero" wrote in message ... I am currently using Application.Dialogs(xlDialogEditColor).Show to show the built-in dialog colour picker. Is this available as a component that I can embed in a form? Would there be any licencing issues? Ed Ferrero Microsoft Excel MVP http://www.edferrero.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I embed a .lnk file in an Excel form? | Excel Discussion (Misc queries) | |||
| How do you embed an input form into excel? | Excel Worksheet Functions | |||
| vbCode to Link a picture to a user form rather than embed it | Excel Programming | |||
| User form or embed in a worksheet | Excel Programming | |||
| Embed a form? | Excel Programming | |||
Linear Mode
