B
Ben in CA
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!
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!