Data Entry Box

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

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?
 
If you're working with a table (column headings, one row per record, etc),
you may be able to use Data - Form.
 
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.??
 
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
 
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.
 
Does anyone who wants to use the form have to download the add-on? Or,
is the add-on automatically attached to the workbook?
Click to expand...

Everyone must download this Add-in
 
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
 
Press alt + F11, double click ThisWorkbook in the project pane to the left
and paste it there
 
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


Peo Sjoblom said:
Press alt + F11, double click ThisWorkbook in the project pane to the left
and paste it there
Click to expand...
 
Back
Top