Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel on a Form
Boys and Girls,
Sometimes I wonder if I simply do not get this whole programming thing. I have an application written in Excel VB. On one of my input forms I want to have the user input information via a grid-like-input-region (you know something like a worksheet). I cannot see how/what control will let me do this? In my mind it is as simple as putting a "mini" spreadsheet on a form and the only answer I could find is using "Office Web Components" Could someone please confirm that this is the only (or best) solution or as I said am I missing the point Sean P.S. An even more attractive solution would be to have a "mini" MS Access table on my form, but one step at a time *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel on a Form
Sean,
In your VB window go "Tools" - "Additional Controls" Add: Microsoft Office Spreadsheet #.# (I don't know what version you'll have, I have 9.0) If this doesn't meet your needs, there are many other additional controls to try out. Dan E "Sean Howard" wrote in message ... Boys and Girls, Sometimes I wonder if I simply do not get this whole programming thing. I have an application written in Excel VB. On one of my input forms I want to have the user input information via a grid-like-input-region (you know something like a worksheet). I cannot see how/what control will let me do this? In my mind it is as simple as putting a "mini" spreadsheet on a form and the only answer I could find is using "Office Web Components" Could someone please confirm that this is the only (or best) solution or as I said am I missing the point Sean P.S. An even more attractive solution would be to have a "mini" MS Access table on my form, but one step at a time *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel on a Form
I have never used one, but I believe a flexgrid control does this (or
probably any control that has "grid" in its name). Regards, Tom Ogilvy "Sean Howard" wrote in message ... Boys and Girls, Sometimes I wonder if I simply do not get this whole programming thing. I have an application written in Excel VB. On one of my input forms I want to have the user input information via a grid-like-input-region (you know something like a worksheet). I cannot see how/what control will let me do this? In my mind it is as simple as putting a "mini" spreadsheet on a form and the only answer I could find is using "Office Web Components" Could someone please confirm that this is the only (or best) solution or as I said am I missing the point Sean P.S. An even more attractive solution would be to have a "mini" MS Access table on my form, but one step at a time *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel on a Form
Thanks Dan E,
The "Microsoft Office Spreadsheet #.#" is the "Office Web Component" I was refering to. I just was not sure if this was designed for specific use on the web, or for general purposes? I will run with this one then Thanks again Sean *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) |