| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advice on Using "xlDialogPatterns"
Hi all, i am sure this is simple for the guru's out there.. How does
one, after making a color selection on the dialog get the value to use as a variable ? Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Advice on Using "xlDialogPatterns"
I have found the answer on another site at the following address, thank
you... http://www.microsoft.com/communities...ult.aspx?query =xldialogpatterns&dg=microsoft.public.excel.progra mming&cat=en_US_3a793e 1f-4961-419d-9ec7-899d6e6086cd&lang=en&cr=US&pt=&catlist=&dglist=&pt list =&exp=&sloc=en-us Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Advice on Using "xlDialogPatterns"
Sorry, just a further question to this.
Does the dialog box only color the active cell or can it be forced to color another cell ??? Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Advice on Using "xlDialogPatterns"
Just as I stated in the link you cited, it is like doing it from the menu -
so only the selection at the time you make the selection. You might want to look at John Walkenbach's site. He has done all the hard work of putting together a color picker on a userform: http://www.j-walk.com/ss/excel/tips/tip49.htm -- Regards, Tom Ogilvy "Les Stout" wrote: Sorry, just a further question to this. Does the dialog box only color the active cell or can it be forced to color another cell ??? Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Advice on Using "xlDialogPatterns"
Thank you so much Tom, that is exactly what i was looking for...
Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Request advice on Split(sFile, "\") | Excel Programming | |||
| newsgroup advice "selecting" | Excel Programming | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Advice needed: "Portable" macros? | Excel Programming | |||
![Les Stout[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
