combination box to cell

C

Chris A

How do i get my choice from a combobox on a user form to a cell in the
worksheet additionally how to do this with a number of cells in one row then
repeat for the row below.
do i need anyhitng in the cells to accept the .value = "whatever"
TIA
 
H

Henry

Chris,

Private Sub ComboBox1_Change()
Sheets("Sheet1").Range("A1") = ComboBox1.Value
End Sub

HTH
Henry
 
U

Urabnite

Your a STAR, I can see me using this one quite alot at the moment, people
seem to struggle with 20+ cells to fill in but can hadle a form with 5 at a
time, so from everyone at work,
Cheers, lots good times going you way.
Chris
 

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

Copy addition formula of non-consecutive horizontal cells 2
Excel does not accept text format! 0
Word macro that can call cells out of Excel for a find and replace 0
Fill cells based on the other 3 cells unique combination the value on the target cell 0
Need Help with a VBA subroutine 0
Merging from an Excel file with graphics 1
VBA Coding Help for Beginner 0
Possible to Combine reports to's to a single box? 0

Top