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

Recommended Answers

All 4 Replies

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.

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

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.