MrExcel.com - Your One Stop for Excel Tips & Solutions

transfer/copy text in textbox and what is selected in combobox of a userform?

Posted by Ben on April 20, 2001 10:50 AM

Could anyone please tell me how to transfer/copy what has been typed into a textbox and what is selected in a combobox in a userform into cells using a macro. The macro will be run form a command button on the userform.

Thanks

Posted by Dave Hawley on April 20, 2001 11:09 AM

Hi Ben

Private Sub CommandButton1_Click()
Sheets("Sheet1").Range("A1") = Textbox1.Text
Sheets("Sheet1").Range("A2") = ComboBox1.Value
End Sub

Dave

OzGrid Business Applications