title: Excel: Is it possible to converge several ComboBox outputs into a single Cell?
body: <p><strong>Context</strong>: My Excel worksheet consists of a userform that outputs to several sheets. A function of this userform is a date selector, that is desired to output to a single cell. However, due to the nature of its design (Obtained from a gentleman from this particular site, Doug Glancy) it consists of three comboboxes.</p>
  
  <p><strong>It is displayed as</strong>:</p>
  
  <p>[ComboBox1: Day] [ComboBox2: Month] [ComboBox3: Year]</p>
  
  <p><a href="https://i.stack.imgur.com/N4Rdn.jpg" rel="nofollow noreferrer">Here is an image for visual reference</a></p>
  
  <p>Is there any particular method of forcing a concrescence from several outputs into a single cell? And if not, what would be an alternative method for accomplishing a similar result?</p>
  
  <p>Edit: Here is my current code for transmitting data from the userform:</p>
  
  <pre><code>    Sub Transfer()
  
  Dim emptyRow As Long
  
  'Make Sheet2 active
  Sheet2.Activate
  
  'Determine emptyRow
  emptyRow = WorksheetFunction.CountA(Range("B:B")) + 1
  
  'Transfer information
  Cells(emptyRow, 2).Value = TextBoxSON.Value
  Cells(emptyRow, 3).Value = TextBoxJobDescription.Value
  Cells(emptyRow, 4).Value = TextBoxCustomer.Value
  Cells(emptyRow, 5).Value = TextBoxQuantity.Value
  Cells(emptyRow, 6).Value = TextBoxDateRequired.Value
  
  Dim LR As Integer
  LR = Range("B" &amp; Rows.Count).End(xlUp).Row
  Application.EnableEvents = False
  Range("A4:BB" &amp; LR).Sort Key1:=Range("A4"), Order1:=xlAscending, _
      Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
  Application.EnableEvents = True
  
  End Sub
  </code></pre>
  
  <p>Edit: Big thanks to <a href="https://stackoverflow.com/users/7446760/clr">CLR</a> for the answer:</p>
  
  <pre><code>mydate = DateSerial(cboYear.Value, cboMonth.Value, cboDay.Value)
  Cells(emptyRow, 6).Value = mydate
  </code></pre>
  
  <p>This code enables the data to be output exactly as desired. Hope this helps anyone in the future.</p>
  
  <p>(<strong>Irrelevant (But seemingly necessary) information</strong>: Hey, I'm a new SO user. After hours (and hours) of trying to find and understand this problem, I have not arrived to any possible conclusion and, with the angry hands of the clock pointing furiously at me, I am forced to (shamefully) ask this question. </p>
  
  <p>I am not Excel proficient nor VBA literate. However, I have been slowly learning the language through sites such as HomeandLearn.org to overcome my difficulties but seemingly to no avail on this particular problem. I must apologise in advance for any inappropriate use or misuse of terminology or any other uninformed misapprehension that has been made in my above question. I have attempted to familiarise myself with the community and the rules of this site before asking this question and have searched extensively for an answer. </p>
  
  <p>Any assistance would be appreciated. Thank you.)</p>