This code copies the value of combobox1 and puts it in the active cell
when the command button is clicked.
Private Sub CommandButton1_Click()
Dim str As String
str = ComboBox1.Value
ActiveCell.Value = str
End Sub
If I have checkbox1 checked on the userform containing this code, I want the above value to go to the next cell on the right to the activecell as well as the activecell when the button is pressed.
Cheers
Stuart
when the command button is clicked.
Private Sub CommandButton1_Click()
Dim str As String
str = ComboBox1.Value
ActiveCell.Value = str
End Sub
If I have checkbox1 checked on the userform containing this code, I want the above value to go to the next cell on the right to the activecell as well as the activecell when the button is pressed.
Cheers
Stuart
Last edited: