Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add drawing shapes to Userform
Hello,
I have a userform that will show folks if certain tables are available. The clerks pulling up the reservation form will see several square objects which will represent tables. If I find a table drawing shape, that would be great. If the table is available (simple value on the spreadsheet), I will change it to green. If the table is not available, I need to turn it to red. Once the clerk, clicks the objects, I need to turn it to blue (chosen). I don't see where I can add the drawing shapes available in the spreadsheet to the form. I know with the drawing object, you can change colors. Does anyone know how to add drawing shapes to the userforms? I guess as worst case, I can place labels ont he form and just change those colors. Not as fancy though. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add drawing shapes to Userform
See Andy Pope's demo
http://andypope.info/vba/userformdraw.htm Regards, Peter T "Webtechie" wrote in message ... Hello, I have a userform that will show folks if certain tables are available. The clerks pulling up the reservation form will see several square objects which will represent tables. If I find a table drawing shape, that would be great. If the table is available (simple value on the spreadsheet), I will change it to green. If the table is not available, I need to turn it to red. Once the clerk, clicks the objects, I need to turn it to blue (chosen). I don't see where I can add the drawing shapes available in the spreadsheet to the form. I know with the drawing object, you can change colors. Does anyone know how to add drawing shapes to the userforms? I guess as worst case, I can place labels ont he form and just change those colors. Not as fancy though. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add drawing shapes to Userform
Thanks Peter!
"Peter T" wrote: See Andy Pope's demo http://andypope.info/vba/userformdraw.htm Regards, Peter T "Webtechie" wrote in message ... Hello, I have a userform that will show folks if certain tables are available. The clerks pulling up the reservation form will see several square objects which will represent tables. If I find a table drawing shape, that would be great. If the table is available (simple value on the spreadsheet), I will change it to green. If the table is not available, I need to turn it to red. Once the clerk, clicks the objects, I need to turn it to blue (chosen). I don't see where I can add the drawing shapes available in the spreadsheet to the form. I know with the drawing object, you can change colors. Does anyone know how to add drawing shapes to the userforms? I guess as worst case, I can place labels ont he form and just change those colors. Not as fancy though. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drawing shapes move when printing | Charts and Charting in Excel | |||
Drawing Shapes on Forms | Excel Programming | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
Drawing shapes in a chart | Charts and Charting in Excel | |||
Drawing shapes on Userform | Excel Programming |