combo box value equals value of 2 text boxes

gr8trthanu

Board Regular
Joined
Nov 14, 2008
Messages
103
Hello,

I have a combo box entitled cmbSearch which I would like its value to be the joining values of textbox "txtLast" and textbox "txtFirst" with a comma and a space after the last name.

The code I am using which I thought was pretty straight forward is below

CODE
____________________________________________________________________

'cmbSearch.Value = txtLast.Value & "," & " " & txtFirst.Value

However, when I select my add command button only the last name appears on excel.

Is there something obvious that I am missing.

The final product should look like the below:

Robertson, John

Thanks in advance
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Your syntax is a bit off:

Code:
Sheet1.ComboBox1.AddItem Sheet1.TextBox1.Text & "," & Sheet1.TextBox2.Text
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top