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.

quick excel question

Thread Tools
 
Old Jan 30, 2008 | 05:57 PM
  #1  
jwakamud's Avatar
Thread Starter
Junior Member
 
Joined: Sep 2002
Posts: 0
Likes: 0
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.
Reply
Old Jan 30, 2008 | 06:35 PM
  #3  
singscountry1967's Avatar
Junior Member
 
Joined: Aug 2005
Posts: 1
Likes: 0
From: North of Buffalo, NY *** NEBF '05, '06, '07 *** ***ONBF & NYBF 06; 07*** ***WCBF 06***
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.
Reply
Old Jan 30, 2008 | 06:41 PM
  #4  
Blownville's Avatar
Senior Member
Posts like a Northstar
 
Joined: Jul 2006
Posts: 547
Likes: 1
From: Waukesha, Wisconsin
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.
Reply
Old Jan 30, 2008 | 07:03 PM
  #5  
jwakamud's Avatar
Thread Starter
Junior Member
 
Joined: Sep 2002
Posts: 0
Likes: 0
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.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
zigmeisterxiv
1992-1999
1
Feb 10, 2010 07:42 PM
ferullo0
Performance, Brainstorming & Tuning
3
May 7, 2007 04:09 PM
Technical Ted
Lounge
10
Oct 29, 2006 09:55 PM
Rh-94SSE
1992-1999
2
Aug 16, 2002 10:41 AM
99BonnevilleSE
General GM Chat
3
Dec 31, 1969 07:00 PM




All times are GMT -4. The time now is 07:13 PM.