Hi,

I'd like a macro that does the following logic when I press a command button
- how do I format this "code" for Excel's Visual Basic?

onclick {
if cell W6 of this worksheet is not empty or zero, copy it to field W6 on
worksheet "Sales" - unless that field is already full, then prompt to replace
or leave existing value.
}

Also, how do I clear a particular field in a different worksheet using a
macro command button?

Any responses appreciated!