Option Buttons for text

[capneddie]

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.

[jaslake]

Well, it's been a while and you've had no response so, I'm what you got. If you are still pursuing this, a sample of your workbook with the code you've created and an example of what the results will look like when donewill be helpful.

Having this will perhaps answer questions such as

a line or text or a number to appear

...what line, text, number? Where will the line, text or number come from? User input form? Another worksheet? Validation required?

You indicate you want the line or text or number

to appear in the next available space on a worksheet

That's a little broad. The first blank row in Colume A; Colume G?

I'll be glad to look at this issue with more information provided.

J