Form for data entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to create a form for entering data onto a spreadsheet? I know
I can in Access, but is there a way to do that in Excel?
 
Like Bob said, Excel has a built in data entry form of sorts. It is
located in Data-->Form. To create your own custom form, you need to
create a UserForm in VBA and put in the necessary code to send the
values from the completed code to your worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation list in data entry form 4
Excel Concatenate Form Name to Parse for function 1
Excel VBA - Problem with Closing Print Preview 0
Data Entry + Validation 3
Access Form Refresh 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Data Entry Form 3
Drop-Down Menus in Data Entry Form? 2

Back
Top