Is there a work-a-round i can use for making a datagrid....

[Mr. GetRight]

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?

 

[Rick Rothstein]

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.

 

[JLGWhiz]

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]

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.