Simple question - I have NO vb skills (as yet) and I need to know how to carry out the setvalue macro command in vba.
I have a form opening on an "on not in list" event so that a new drop down optoin can be added and I want to carry across the new value that was typed in from the main form to this new value form.
Is there a simple line of code to carry the value across??
It's driving me mad, but I simply don't know the syntax of vba...
Thanks!