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.

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.

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.