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.

See Andy Pope's demo

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

Regards,
Peter T

"Webtechie" <(E-Mail Removed)> wrote in message
news:7D51C56B-282D-4FDA-8448-(E-Mail Removed)...
> 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.

Thanks Peter!

"Peter T" wrote:

> See Andy Pope's demo
>
> http://andypope.info/vba/userformdraw.htm
>
> Regards,
> Peter T
>
> "Webtechie" <(E-Mail Removed)> wrote in message
> news:7D51C56B-282D-4FDA-8448-(E-Mail Removed)...
> > 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.
>
>
>