macro & comobox

  • Thread starter Thread starter pandino
  • Start date Start date
P

pandino

I have a combobox with 10 items in the first line of an
excel sheet column. I'd like to create a macro to fill
active cell with a value from this combobox. How should I
do?
Thanks for support!
 
Private Sub Combobox1_Click()
ActiveCell.Value = Combobox1.Value
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox default text 3
Iterating through a ComboBox's values 6
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Cut and paste with a combobox 0
one combobox affecting another 1
Hide Range of Cells 1
Combobox Population 6
macro & combobox 1

Back
Top