Member Avatar for andyshera

Hello everyone my name is andy...
is anyone know how to make a simple data entry worksheet in excel 2007?
i noticed that excel 2007 have a form control inside the developer tab
i can add input text box and command button in sheet1

but i dont know what syntax to insert inside that text box and command button
so if i click the command button anything i've inserted inside the text box will
be added to sheet2 as data records

please help

thank you

Edited by Reverend Jim because: wrong forum
  • 4 Contributors
  • 4 Replies
  • 242 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by jwenting
Member Avatar for LastMitch

Does anyone know how to make a data entry worksheet in excel 2007?

it's called this:

http://office.microsoft.com/en-us/excel-help/about-macros-in-excel-HP005201201.aspx

It record data calculation. You insert the calculation and then you enter the data and it will calculate the data and displayed the results.

It's more like visual basic which I am not familiar with.

Edited by LastMitch because: grammer
Member Avatar for andyshera

thx for your reply...
but still not answer my question about syntax

Member Avatar for jwenting

Excel IS a data entry worksheet :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.