On Wednesday, June 15, 2016 at 6:30:00 PM UTC-5, GS wrote:
Not to discount Peter's sage advise...

FWIW
When I make forms I start with a blank sheet setup like graph paper
so I can use cells as checkboxes or disguise them as buttons. This
makes the form orders of magnitude more stable/reliable/efficient,
especially when the form uses outlines to expand/collapse sections.
Code for checkbox cells is put in event code behind the worksheet
wherein 'Target' address is evaluated in a Select Case construct to
match the checkbox cell's named range. Event code also places a
checkmark (via Wingdings2 font) in the cell whenever anything is
entered. (I instruct to use the spacebar)

This approach has totally eliminated 'sheet control hell', and
enables making interactive forms with fantastic ease! Let me know
if you're interested to learn more...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Thanks, Garry, I appreciate your help. I'm not a programmer, so your
a little beyond my capabilities! James

If you already use code then you won't have much trouble working from a
sample. The code is boilerplate...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus