Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a formula Work.... PZ[_2_] Excel Programming 2 October 1st 08 07:02 PM
Round doesnt work the way it is expected Carlo Excel Discussion (Misc queries) 13 December 21st 06 12:26 AM
Making this formula work Kleev Excel Worksheet Functions 5 December 15th 05 01:42 AM
Making VBA code from one WB work on another WB ForestRamsey Excel Programming 2 December 6th 05 06:39 PM
How to make excel not round real numbers when making a histogram? Leedawg Charts and Charting in Excel 1 September 21st 05 07:36 PM


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"