Copy from Combobox to Sheet

skamat · Jan 31st 2013

Dear Sir
Please see the attached sheet in which I have written the text "YOU ARE IN THE MONTH OF"

Now I have already created a combobox (shown in this example sheet) in which all the months are mentioned from January to December.

Now when I click on any month and click GO I want the month to be shown in Sheet1, after the text YOU ARE IN THE MONTH OF

That means when January is selected then it should display YOU ARE IN THE MONTH OF JANUARY.
Then same for all months when selected

**pike** · Jan 31st 2013

Re: Copy from Combobox to Sheet

Hi skamat
code for your command button

Code

Private Sub CommandButton1_Click()
Range("B3").Value = "You Are In The Momth Of " & Me.ComboBox4.Value
End Sub

skamat · Jan 31st 2013

Re: Copy from Combobox to Sheet

Great Thanks

Participate now!