Trying to place radio buttons using vba in a form. With a for next loop

What I am trying to do is make a custom form based on values from the worksheet. I am looking up the values and using a for next loop to place the buttons on the form. I am also pulling the information for the buttons caption from the worksheet. I can get it to almost work until I try to use a variable. The problem is in this part of the code. I think.UserForm1.Controls.Add("Forms.inputbutton", "radioname", True)
Maybe I need to declare inputbutton as something other than variant. I am getting the error (Invalid string class ) Thanks for the help. I will post my code when I figure out how to do that.

This is my code. I am trying to use a variable that increases on each loop that will get the next value from the worksheet. I hope that I put the code in the correct way.

Please Login or Register  to view this content.

Thank You. It worked great. I was wondering if you could give me a little tutorial on how this works. It looks like the main part is DIM OPT AS MSFORMS.OPTIONBUTTON. BUt I am a little confused on what is going on behind the scenes. I would like a better understanding because this is just the start of my project and I will be needing to pull all sorts of data from different sheets based on what the user enters. via-check boxes, input fields and buttons. Thanks again.