combobox with two columns?

[behedwin]

i have this code to populate a combobox

Please Login or Register  to view this content.

but i want to populate a combobox with both data from b column and c column.

how do i do this?

in b column i have first name
in c column i have last name

in the combobox i want to show full name

and it is important that the combobox updates when another row of names is added... so i cant have fix range.

[Norie]

Try this.

Please Login or Register  to view this content.

[Norie]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[behedwin]

okey, wont happen again.

[behedwin]

Try this.

Please Login or Register  to view this content.

This one did not work.

[Norie]

In what way didn't it work?

Did the original code work to add the first names to the combobox?

[behedwin]

In what way didn't it work?

Did the original code work to add the first names to the combobox?

It dident work, i got an error that says something about "object does not suppor the property of the method" (translated from swedish)

see screenshot : http://prntscr.com/ct1rl4

the original code works fine to just fetch the column B data into the combobox

[mikerickson]

There is a "t" at the end of Offset that is missing in post #2

[behedwin]

haha, that was the issue.

Thanks for your help!!
Works perfectly now

[behedwin]

Ok im stuck again lol

that code that i got working now sadly made my delete row code fail.

Please Login or Register  to view this content.

this code is suppose to delete the row of the value i pick in the combobox

but now when i am using this code

Please Login or Register  to view this content.

to populate the combobox
the value in the combobox is not matched to a singel value in column B.

I can not see how to solve this easily?
like if column B value and column C value matches (including a " " ) then delete....
or is there another solution?

[Norie]

In the delete code instead of just looking for a match in column B look for a match in column B & " " & column C.

Please Login or Register  to view this content.

[bakerman2]

Some remarks.

1. Avoid looping too many rows.
2. It's good practice when deleting rows to work from bottom to top to avoid unwanted results (even though in this case there's probably only 1 row to delete).

Please Login or Register  to view this content.

[behedwin]

In the delete code instead of just looking for a match in column B look for a match in column B & " " & column C.

Please Login or Register  to view this content.

great
tried to do this but used the wrong commands.
this works good!