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
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