Data Entry Box

[sowetoddid]

Can anyone tell me where i can find help or instruction on creating a
data entry box? I am not certain on the actual name of this feature.

I would like to have a grey box show up to the user. inside the box, I
can designate various categories and have white openings for data
entry.

Once the user enters the data and clicks OK, the spreadsheet will
automatically be populated in the appropriate places.

I know that this is easily done in access, but what about in excel.
Does anyone know VBA code or another method to doing this?

 

[Earl Kiosterud]

If you're working with a table (column headings, one row per record, etc),
you may be able to use Data - Form.

 

[sowetoddid]

Thanks. I actually never realized that was there.

Is there a way to restrict the usability more?

The people who input data into my form will not be very computer
literate. The more buttons and slidebars they see, the more confusing
it becomes.

Is it possible to create a "form" that looks like that one but only
allows a person to add data and not scroll through the other data,
delete records, etc.??

 

[Ron de Bruin]

Or better, use this one
http://www.j-walk.com/ss/dataform/index.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

If you're working with a table (column headings, one row per record, etc),
you may be able to use Data - Form.

 

[Gerry Kuta]

Private Sub Workbook_Open()
With Sheets("Sheet1")
Application.Goto .Range("A2")
.ShowDataForm
Application.Quit

End With
End Sub

works well too... in VBAProject (Alt F11)(This Work Book)
paste the above.
HTH

 

[sowetoddid]

One question about J-Walk's form (in the link)...

Does anyone who wants to use the form have to download the add-on? Or,
is the add-on automatically attached to the workbook?


Thanks.

 

[Ron de Bruin]

Does anyone who wants to use the form have to download the add-on? Or,

is the add-on automatically attached to the workbook?

Everyone must download this Add-in

 

[sowetoddid]

another question...

Do I tie this code to a command button??

Private Sub Workbook_Open()
With Sheets("Sheet1")
Application.Goto .Range("A2")
ShowDataForm
Application.Quit

End With
End Sub

 

[Peo Sjoblom]

Press alt + F11, double click ThisWorkbook in the project pane to the left
and paste it there

 

[Peo Sjoblom]

Sorry, I meant paste it into the window that opens when you double click
ThisWorkbook,
I can see how my earlier post my be misunderstood

--

Regards,

Peo Sjoblom

Press alt + F11, double click ThisWorkbook in the project pane to the left
and paste it there

 

[sowetoddid]

Great. I got it.

thanks