quick excel question - GM Forum - Buick, Cadillac, Chev, Olds, GMC & Pontiac chat


Lounge For casual talk about things unrelated to General Motors. In other words, off-topic stuff. And anything else that does not fit Section Description.

Reply
 
 
 
Thread Tools Search this Thread
Old 01-30-2008, 06:57 PM   #1
Junior Member
Thread Starter
 
Join Date: Sep 2002
Posts: 0
Thanks: 0
Thanked 0 Times in 0 Posts
jwakamud is on a distinguished road
Default quick excel question

is there a way in an excel worksheet to have a checkbox?

im thinking like a list of things, and check the ones i have, just by clicking the box.
jwakamud is offline   Reply With Quote
Old 01-30-2008, 06:59 PM   #2
Darrel
Guest
 
Posts: n/a
Default

well, in office 2007 you can. under the developer ribbon click on insert and choose the check box.

you'll have to add the developer ribbon most likely though. i think in that case you just click on the office logo and then on options. check the "show developer tab in ribbon" and you're good to go!
  Reply With Quote
Old 01-30-2008, 07:35 PM   #3
Junior Member
 
Join Date: Aug 2005
Location: North of Buffalo, NY *** NEBF '05, '06, '07 *** ***ONBF & NYBF 06; 07*** ***WCBF 06***
Posts: 0
Thanks: 0
Thanked 0 Times in 0 Posts
singscountry1967 is on a distinguished road
Default

Which version of excel do you have? I just got the 2007 and haven't figured it all out yet.. I did a quick search through help but came up empty.

What you could do is improvise.... reduce the width of the column you want to use as the checkmark box....and type in an "x" instead of a checkmark for items that are completed.
singscountry1967 is offline   Reply With Quote
Old 01-30-2008, 07:41 PM   #4
Senior Member
Posts like a Northstar
 
Join Date: Jul 2006
Location: Waukesha, Wisconsin
Posts: 547
Thanks: 0
Thanked 0 Times in 0 Posts
Blownville is on a distinguished road
Default

Yes I know for sure that you can. My partner at work is an Excel wiz and can do just about anything. The only thing is that I don't know how to do it myself. Anyways I think he uses Macro'* for the interface that is linked to the sheet that it populates. I know he does a bunch of programming with the Macro'* to achieve this. Just search how to use Macro'* in Excel.
Blownville is offline   Reply With Quote
Old 01-30-2008, 08:03 PM   #5
Junior Member
Thread Starter
 
Join Date: Sep 2002
Posts: 0
Thanks: 0
Thanked 0 Times in 0 Posts
jwakamud is on a distinguished road
Default

thanks for your help everyone.

its in "forms" . . . but its not exactly the most friendly tool. ill go with a simple Y/N entry.
jwakamud is offline   Reply With Quote
 
 
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
Quick VATS question ... Update w. airbag light question zigmeisterxiv 1992-1999 1 02-10-2010 08:42 PM
QUICK! QUICK! SPEED! QUICK! ferullo0 Performance, Brainstorming & Tuning 3 05-07-2007 05:09 PM
Need help in Excel Technical Ted Lounge 10 10-29-2006 10:55 PM
Quick Question Rh-94SSE 1992-1999 2 08-16-2002 11:41 AM
Quick Question... 99BonnevilleSE General GM Chat 3 12-31-1969 08:00 PM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 01:16 AM.


We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.