I have several option buttons on a userform I created. When I click the button I want a line or text or a number to appear in the next available space on a worksheet. I developed the worksheet and code per an online tutorial on using VBA to develop a parts location worksheet.