Combobox combining 2 named ranges

[gsandy]

I have two named ranges “FirstName” & “LastName” and wish a single column combobox (cmbName) to show a concatenation of the two ranges i.e. “Joe Bloggs”.
What would the form initialization code be?
Thanks Sandy

[mjr veverka]

E.g.:
Module1 module:

Please Login or Register  to view this content.

UserForm1 module:

Please Login or Register  to view this content.

Sheet1 module:

Please Login or Register  to view this content.

Worksheet "Sheet1":

[gsandy]

Thanks Porucha I will test the code tomorrow and let you know.

[gsandy]

Thanks again Porucha the code worked a treat.
For some reason I had to comment out the named range test (which included "MsgBox "O no no no no !"")!
Cheers Sandy

[mjr veverka]

... Oh, no no no no ! ...
Oh, yes ...

[gsandy]

Where is "drevni ruchadlo"?

[mjr veverka]

In the land of a smile, such a Smile Land ...
Unfortunately, sometimes it is very sad here ...

[gsandy]

Come to New Zealand, land of Hobbits, for a smile!

[mjr veverka]

Ok, if I don't get lost, by sailing there in a my miniature four-wheeled submarine ...