Add drawing shapes to Userform

[Webtechie]

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.

 

[Peter T]

See Andy Pope's demo

http://andypope.info/vba/userformdraw.htm

Regards,
Peter T

 

[Webtechie]

Thanks Peter!

See Andy Pope's demo

http://andypope.info/vba/userformdraw.htm

Regards,
Peter T