Hi Vivi,
You can Record a macro or procedure as visual basic by
ToolsMacroRecord New Macro ... or you can buy new book about how to
write procedure by your self

Rgds,

halim

vivi menuliskan:
Hi this is the first time I've ever thought of doing this and I really need
someone to help me please!!

I've created a check box in excel and it's marked "complete", if this box is
ticked i.e. the data is entered completed then the macro would allow the user
to run the macro normally allowing the user to copy the data entered from the
sheet for example sheet 'dataentry1' to the 'summary sheet' as text/value
only then select worksheet 'dataentry1' and paste it to the same work book as
worksheet 'dataentry2' with automatic clearing of all data that has been
entered for 'dataentry1' then hide and protect 'dataentry1' as well, i would
also like to put a order number in a cell as well which is always going to be
1 digit higher than the previous form i.e. 'dataentry1' has an order number 1
and macro can put order number 2 in 'dataentry2' accordingly.

However if the the checkbox marked "completed?" is not ticked and few
messages will come up for example 'have you enter your user id?' or 'have you
enter the address?' or 'have you enter ticked check box - delivery/local pick
up? ' depending on which data is missing and cannot be transferred to the
summery sheet.

Also I want the check box 'completed' to be automatically tick itself once
all the mandatory fields are entered rather than allowing the users to tick it

I know this is complicated and I might not have explain myself properly but
I really wish to learn visual basis and to be able to perform this task

Thanks for your urgent help!!

Vivi