| Chat with a LIVE Microsoft
Access Expert! |
||||
|
|
|||
|
||||
|
||||
|
#1
05-22-2007, 10:27 AM
|
|||
|
|||
|
Excel 2007: Checkbox??
Dear Excel Gurus,
I'm partially embarrassed to ask such a basic question, but I need help with checkboxes. How do you create a checkbox in Excel 2007? Microsoft has changed the formatting menus so much, I am totally lost. It's not the way it used to be "view | toolbars --> forms" in previous versions of Excel. If you have Excel 2007 and know how to use this feature, can you help me create a checkbox? It's for a simple checklist spreadsheet. Best, Mike P.S. If it happens to be a complicated bit of VB code, that is fine with me! 
|
| Sponsored Links |
|
#2
05-22-2007, 10:41 AM
|
||||
|
||||
|
Okay, first you have to make sure you can get the Developer ribbon and to do that you go to the Windows icon and select Excel Options. Then, under POPULAR select "Show Developer Tab in the Ribbon" and then after clicking OK you can then select the Developer Tab and then INSERT from the Ribbon.
__________________
Thanks, Bob Larson Free samples, tools and tutorials (including Auto Frontend Update Enabling Tool) "Have you tried turning it off and on again?"
|
|
#3
05-22-2007, 10:51 AM
|
|||
|
|||
|
Cheers, Bob. I really appreciate it...
|
|
#4
05-22-2007, 10:53 AM
|
||||
|
||||
|
No problem - it does take some getting used to the new interface. I do like Office 2007 but it is a bit of a challenge, at times, to overcome the previous knowledge of where things were.
__________________
Thanks, Bob Larson Free samples, tools and tutorials (including Auto Frontend Update Enabling Tool) "Have you tried turning it off and on again?"
|
|
#5
05-22-2007, 11:02 AM
|
|||
|
|||
|
Actually, now that I have this, do you know if there is a way that I can increase the size of the checkbox? This is a simple checklist that will be printed, given to work crew to check off elements of a list, and then return it to the office for soft storage. A larger check box would be easier for them. Any ideas? Thanks again
|
|
#6
05-22-2007, 11:04 AM
|
||||
|
||||
|
Not sure about that one. I'd have to play around with it to see (I don't have it here at work, just at home).
__________________
Thanks, Bob Larson Free samples, tools and tutorials (including Auto Frontend Update Enabling Tool) "Have you tried turning it off and on again?"
|
|
#7
05-22-2007, 11:07 AM
|
|||
|
|||
|
Cool... It's not really an urgent task. I'm not even sure If you can do it in Access. I remember having this issue before in the past and not being able to figure it out then. If you stumble across it, that would be great. If I figure it out, I will post the solution
Thanks again, Bob! Mike
|
|
#8
05-19-2008, 12:28 PM
|
|||
|
|||
|
Quote:
I do not follow... go to the Windows icon where?
|
|
#10
07-04-2009, 11:05 AM
|
|||
|
|||
|
Re: Excel 2007: Checkbox??
So, thanks for the instructions. I also was going to ask if there was a way to have the checkboxes inside the cells of an entire column?
|
|
#11
08-10-2009, 04:06 AM
|
|||
|
|||
Re: Excel 2007: Checkbox??
Our security policies mean that our end users do not have the Developer Tab enabled.
Is there another way that they can enter tick boxex in their speadsheets?
|
| Sponsored Links |
 |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Appending an Excel file to an Access table | adrian.stock22 | General | 7 | 12-12-2008 01:47 PM |
| Import Excel 2007 spreadhshet into Access 97 | boscorelli | Queries | 5 | 03-29-2007 02:05 AM |
| Trying to update a checkbox in excel from access public sub | ShiftyJaffa | Modules & VBA | 1 | 11-10-2004 10:44 PM |
| Web form data import | franciscorua | Modules & VBA | 2 | 12-19-2003 09:57 PM |
| Web form data import | franciscorua | Tables | 1 | 11-28-2003 04:29 AM |
Linear Mode
