UserForm selection transferred 2 spreadsheet???

[KrisB_bacon]

Hi

Is it possible in a userform, to have a combo box with data (lets sa
different years, 2003,2004 to 2008) and after the user presses a butto
on that, for it to takes the user to a worksheet and puts a word in th
appropriate cell (e.g. Yes).

So.........there's a column of years and then, depending on what yea
the user selected, the word Yes is entered alongside the year. How do
get this to work?

Shud I use option buttons/check boxes instead??


Thx for any replies

Chri

 

[Bob Phillips]

With the combobox, you can use the data on the sheet as the RowSource to
populate the combobox, and get the Yes with a simple

Private Sub ComboBox1_Change()
Worksheets("Sheet1").Range("A1").Offset(ComboBox1.ListIndex, 1).Value =
"Yes"
End Sub

assuming the years are in sheet1 A1:A6.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)