View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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.