Buttons or Boxes

  • Thread starter Thread starter Wynn
  • Start date Start date
W

Wynn

Monica,
It sounds like you may want to create a User Form in
Visual Basic. Could you explain a little more of what
you'd like to accomplish?

-----Original Message-----
Does anyone know of a way to insert a button or a box
Click to expand...
where you can insert a "x" to select an option.
For example, if I have three options A, B, and C - I
Click to expand...
want to put a box or a circle next to each one that can be
selected or deselected when clicked on. Any help or
insight is much appreciated.
 
Yes, I am thinking along the same lines. I am creating a purchase order document where there will be various options. (We are a printing company and when we send out for bindery services I need to specify what each job requires). The template will be put on our server for all company users to access.

EXAMPLE
Tri
Fol
Perforat
Die-cu

I want to be able to put a box or a circle that can be selected before each option. That way the user can just select it and print out the document. If it is relevant, there are other fields in the document where the description, job name, and number, etc. are entered. I just wanted to find out if this was at all possible or I may have to go about it differently. Thanks.
 
Monica,
Right now I am struggling to learn user forms myself.
Somebody shared this google forum, which is a pretty good
collection of links and tutorials. Let me know if you
come across any good ones yourself!
Wynn

http://www.google.com/groups?threadm=#Xje25x#DHA.1732%
40TK2MSFTNGP12.phx.gbl
-----Original Message-----
Yes, I am thinking along the same lines. I am creating a
Click to expand...
purchase order document where there will be various
options. (We are a printing company and when we send out
for bindery services I need to specify what each job
requires). The template will be put on our server for all
company users to access.
EXAMPLE:
Trim
Fold
Perforate
Die-cut

I want to be able to put a box or a circle that can be
Click to expand...
selected before each option. That way the user can just
select it and print out the document. If it is relevant,
there are other fields in the document where the
description, job name, and number, etc. are entered. I
just wanted to find out if this was at all possible or I
may have to go about it differently. Thanks.
 
I did some more digging and I found the following on another Excel forum. You can insert the form directly in the worksheet without having to go into Visual Basic. Works perfectly. Hope this helps you too.

View -- Toolbars -- Forms. Click the CheckBox icon, then click and drag t
draw one on the worksheet
 
Back
Top