1 drop down box Changes another

[ScottyG]

I have 2 dropdown boxes side by side, each with 2 selection choices. The left one: First Name, Home Phone. The right one: Last Name, Work Phone.

Is there a formula so that if the user selects an item from either box, the corresponding item will be entered in the other box, thus saving them one mouse click?

Thanks for any help!

Scotty

 

[HalfAce]

Hmm. Never tried using a period in a sub's name. Didn't even know we could do that.

 

[Norie]

HalfAce

You can't use a period in a sub name.

Isn't the period being used as a dot qualifier?

 

[ScottyG]

Re

I think the "S3SS." didn't need to be there.

 

[HalfAce]

HalfAce
You can't use a period in a sub name.

Didn't think we could.

 

[Norie]

Can't use ! ,; ,: ,% ,$ ,* , &, (, ), +, -, {, [, }, ], @, ~, #, <, >, /, ?, |, \, / or the humble comma, but you can use £.

 

[HalfAce]

And I thought all we could use was the underscore.
I'll have to start using the '£' character just to throw people off.

 

[Norie]

Oops, missed a couple.

You can use ¬, but alas not `.