Reply to thread

Message: [QUOTE="emmy128, post: 6205414"] Hi I am working on a user form that pops up when the spreadsheet is open, allowing the user to enter all the entries they need to. Each entry is automatically entered one below the other... now, i'd like to have a place on my user form that allows the user to select checkboxes, then have a corresponding cell display the word "yes" if its checked, and to remain blank if its not. how in the heck to i program this... ? my text boxes are all programmed like this: LastRow.Offset(1, 0).Value = TextBox1.Text LastRow.Offset(1, 2).Value = TextBox2.Text LastRow.Offset(1, 3).Value = TextBox3.Text LastRow.Offset(1, 4).Value = TextBox4.Text LastRow.Offset(1, 5).Value = TextBox5.Text and my combo boxes are like this: If ComboBox1.Value <> "" Then _ LastRow.Offset(1, 7).Value = ComboBox1.Value i will have 4 check boxes, that will correspond to columns 8, 9, 10, 11 hope this helps! Thank you in advance! Em~ [/QUOTE]