Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Online Forms in Excel
How do I make an online form (that is put on the server) in Excel with list
boxes and combo boxes on sheet #1 and the data to choose from (that goes in those boxes) on sheet #2? I used to do it all the time, now Ive completely forgotten how and the KB does not even give me a clue€¦..neither does Excel help (or maybe I either missed it or asked the wrong question). I would certainly appreciate any help. Thanks -- Claudia |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Online Forms in Excel
I may be wrong but I think once a file is saved as a web page all of the
ActiveX controls are disabled. Perhaps converting microsoft languge to Java would overcome this? I have been told there are some products on the market that will do this but I have never checked this for myself. "Claudiakc" wrote: How do I make an online form (that is put on the server) in Excel with list boxes and combo boxes on sheet #1 and the data to choose from (that goes in those boxes) on sheet #2? I used to do it all the time, now Ive completely forgotten how and the KB does not even give me a clue€¦..neither does Excel help (or maybe I either missed it or asked the wrong question). I would certainly appreciate any help. Thanks -- Claudia |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Online Forms in Excel
When I talk about an online form, I didn't mean the web (sorry :)), and the
processes I used in the past had nothing to do with either VB or Java. I simply had boxes on one sheet and the data that went in those boxes on another sheet. Problem is, I can't remember the process in between. I do know it all came off the Excel menu, but I cannot remember what menu items and in what order I did them. -- Claudia "scottfoxall" wrote: I may be wrong but I think once a file is saved as a web page all of the ActiveX controls are disabled. Perhaps converting microsoft languge to Java would overcome this? I have been told there are some products on the market that will do this but I have never checked this for myself. "Claudiakc" wrote: How do I make an online form (that is put on the server) in Excel with list boxes and combo boxes on sheet #1 and the data to choose from (that goes in those boxes) on sheet #2? I used to do it all the time, now Ive completely forgotten how and the KB does not even give me a clue€¦..neither does Excel help (or maybe I either missed it or asked the wrong question). I would certainly appreciate any help. Thanks -- Claudia |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making Online Forms in Excel
OK
I think you mean the CONTROLBOX and FORMStoolbars DO VIEWTOOLBARSFORMS OR/AND VIEWTOOLBARSCONTROL TOOLBOX CONTROL TOOLBOX IS THE BETTER OF THE TWO Place the boxes, checkboxes, optionbuttons and so on on you sheet. For Control Toolbox controls Go into design mode (triangle) Select the control and then right click properties Look for linkedcell in properties and type something like: Sheet1!A1 for a dropdown list this could be: Sheet1!A1:A10 These cells and controls will now be linked. Hope that helps "Claudiakc" wrote: When I talk about an online form, I didn't mean the web (sorry :)), and the processes I used in the past had nothing to do with either VB or Java. I simply had boxes on one sheet and the data that went in those boxes on another sheet. Problem is, I can't remember the process in between. I do know it all came off the Excel menu, but I cannot remember what menu items and in what order I did them. -- Claudia "scottfoxall" wrote: I may be wrong but I think once a file is saved as a web page all of the ActiveX controls are disabled. Perhaps converting microsoft languge to Java would overcome this? I have been told there are some products on the market that will do this but I have never checked this for myself. "Claudiakc" wrote: How do I make an online form (that is put on the server) in Excel with list boxes and combo boxes on sheet #1 and the data to choose from (that goes in those boxes) on sheet #2? I used to do it all the time, now Ive completely forgotten how and the KB does not even give me a clue€¦..neither does Excel help (or maybe I either missed it or asked the wrong question). I would certainly appreciate any help. Thanks -- Claudia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I make editable PDF forms using Excel? | New Users to Excel | |||
Associate an e-mailed Excel spreadsheet with Office Online | Excel Discussion (Misc queries) | |||
Forms Toolbar in Excel 2003 | Excel Worksheet Functions | |||
Making an Excel Sheet Available Online | Excel Worksheet Functions |