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.
|