av8tordude
05-10-2010, 01:48 PM
I have 2 combo boxes in a userform. The code below works fine, except i can not figure out a way to enter a comma in between the two words when it enters them into a cell.
Example... If cboCity= Raleigh & cboState = North Carolina, the code enters "RaleighNorth Carolina". I would like it to enter "Raleigh, North Carolina". Can anyone assist. Thank you
.Cells(Cur_Row, "H") = Me.cboCity & Me.cboState
Example... If cboCity= Raleigh & cboState = North Carolina, the code enters "RaleighNorth Carolina". I would like it to enter "Raleigh, North Carolina". Can anyone assist. Thank you
.Cells(Cur_Row, "H") = Me.cboCity & Me.cboState