Combing values from 2 Comboboxes into 1 cell

[Alan T]

Is it possible to have data from 2 comboboxes on a userform to post t
one cell?

The data in the comboboxes is as follows:-

ComboBox1 = 1-31
ComboBox2 = Jan-Dec

If the values selected were 1 and Jan respectively, the cell shoul
display "1 Jan".

Any suggestions

 

[Frank Kabel]

Hi
use the & operator. e.g.
msgbox ComboBox1.text & " " & ComboBox2.text