Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a work-a-round i can use for making a datagrid....
Hey all, I am trying to make a datagrid on a form that the user would input
info, and once completed, it would be put in correct area's of the workbook. I cant use a datagrid as job doesn't alw downloads for net so i cant get the update needed to alw me to use datagrids( see post sugj: "Missing Control In Addin") is there a way i can use a text box or some other box or tool to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a work-a-round i can use for making a datagrid....
When you say "form", do you mean UserForm or worksheet set up to look like a
data input form? If a UserForm, then yes, you can use TextBoxes, but you didn't supply enough information for us to tell you more (for example, how many rows and columns or whether the number of rows and columns are fixed or dynamic)? If a worksheet set up to look like a form, you could just use a portion of the worksheet's grid, perhaps with borders to set it apart from the rest of the worksheet's setup. Oh, and what did you mean by "once completed"... a button to push to signal all data has been input or were you thinking that each entry would go to the "correct area's of the workbook" as inputted? Also, it might help if you could give us an idea of what those "correct areas" are. -- Rick (MVP - Excel) "Mr. GetRight" wrote in message ... Hey all, I am trying to make a datagrid on a form that the user would input info, and once completed, it would be put in correct area's of the workbook. I cant use a datagrid as job doesn't alw downloads for net so i cant get the update needed to alw me to use datagrids( see post sugj: "Missing Control In Addin") is there a way i can use a text box or some other box or tool to do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a work-a-round i can use for making a datagrid....
From what I read about DataGrid, you can do the same thing directly on an
Excel sheet. You might have to use different facilities to execute commands and manipulate data, but it is all there. And as Rick pointed out, there is always the UserForm options that onece set up can be just as efficient (maybe more so) as DataGrid. IMHO, it is just a matter of how much one wants to learn about the appllication. "Mr. GetRight" wrote in message ... Hey all, I am trying to make a datagrid on a form that the user would input info, and once completed, it would be put in correct area's of the workbook. I cant use a datagrid as job doesn't alw downloads for net so i cant get the update needed to alw me to use datagrids( see post sugj: "Missing Control In Addin") is there a way i can use a text box or some other box or tool to do this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a work-a-round i can use for making a datagrid....
I'm using a UserForm,
I have a worksheet that is a templete of a bill to be sent to a customer. The sheet already has the company header, disclaimer, columns heading, and is only missing the detail info like client name, address, products, cost, codes, amount due, etc. Right now i have to go to different screens to collect the info and type it one at a time, or write everything down and then type it to sheet. I figured, i can make an userform, hide the excel sheet, keep the form on top as I go through the diff screens/systems collecting the info and once finish, hit the create button and apply the data to the correct area's of the sheet. The info that would go in the datagrid or textbox would be no more then 8 columns, and as far as the rows, it could be 1 or could be more then 30. I have another project that i'm working to try to save me sometime that involves a few different sheets but if I could get help no this one I could apply it to the other project. Hope this was a little bet more clear. "Rick Rothstein" wrote: When you say "form", do you mean UserForm or worksheet set up to look like a data input form? If a UserForm, then yes, you can use TextBoxes, but you didn't supply enough information for us to tell you more (for example, how many rows and columns or whether the number of rows and columns are fixed or dynamic)? If a worksheet set up to look like a form, you could just use a portion of the worksheet's grid, perhaps with borders to set it apart from the rest of the worksheet's setup. Oh, and what did you mean by "once completed"... a button to push to signal all data has been input or were you thinking that each entry would go to the "correct area's of the workbook" as inputted? Also, it might help if you could give us an idea of what those "correct areas" are. -- Rick (MVP - Excel) "Mr. GetRight" wrote in message ... Hey all, I am trying to make a datagrid on a form that the user would input info, and once completed, it would be put in correct area's of the workbook. I cant use a datagrid as job doesn't alw downloads for net so i cant get the update needed to alw me to use datagrids( see post sugj: "Missing Control In Addin") is there a way i can use a text box or some other box or tool to do this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a formula Work.... | Excel Programming | |||
Round doesnt work the way it is expected | Excel Discussion (Misc queries) | |||
Making this formula work | Excel Worksheet Functions | |||
Making VBA code from one WB work on another WB | Excel Programming | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel |