Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create form fields in excel
I've searched what seems like the entire Microsoft Online site and am having
difficulty finding an answer to what I think you be a very elementary question - how do I insert a form field in Excel? I've successfully created form fields in forms in Word so I get the basic idea of how they work. My problem is, when I am working on the Excel sheet I'd like to insert form fields in, on the forms toolbar, the form field option, the "ab" button is greyed out. I cannot figure out how to activate it or why it is grey in the first place. I've been able to insert checkboxes in Excel no problem so I'm very confused. Anyone with some advice in a foolproof, step by step manner would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create form fields in excel
execassist,
Form fields are a Word entity, to allow naming a certain area within a bunch of text; the term has no meaning in an Excel context, as it is cell based. The nearest equivalent is a named range. When you refer to the Forms toolbar and the "ab", that is for putting a label on top of the worksheet. You seem to be trying to use Excel for a Word job, or using the same methods in Excel as you have in Word. Either way will not work. If this is a job for Excel, forget your practice in Word and utilise Excel for what it is, a spreadsheet. NickHK "execassist" wrote in message ... I've searched what seems like the entire Microsoft Online site and am having difficulty finding an answer to what I think you be a very elementary question - how do I insert a form field in Excel? I've successfully created form fields in forms in Word so I get the basic idea of how they work. My problem is, when I am working on the Excel sheet I'd like to insert form fields in, on the forms toolbar, the form field option, the "ab" button is greyed out. I cannot figure out how to activate it or why it is grey in the first place. I've been able to insert checkboxes in Excel no problem so I'm very confused. Anyone with some advice in a foolproof, step by step manner would be greatly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to create form fields in excel
You can get something close to form fields by designing your form with the appropriate text and labels, etc., then: - unlock only the cells where you desire data to be typed in. - Protect the sheet ---------------- Ben -- protonLeah ------------------------------------------------------------------------ protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097 View this thread: http://www.excelforum.com/showthread...hreadid=535735 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a simple form where users can tab between fields | Excel Worksheet Functions | |||
How do I create drop down form fields in Excel? | Excel Discussion (Misc queries) | |||
How many fields can you have in an EXCEL form? Is there a limit? | Excel Discussion (Misc queries) | |||
Create fields in a form with a fixed length | Excel Discussion (Misc queries) |