Userform Option Buttons

  • I am building a userform to track seminar invitation responses. Amongst other things, the form will contain three option buttons; "Accept, Decline, No Response". However, I am having issues with the coding and cannot find any online resources to help me.

    There will possibly as many as 500 records that will be saved to a spreadsheet. I *think* my main issue is with the Range always pointing to C3.

    It would be great if anyone has any suggestions or can point me to a good online resource.


    Here is the code I have so far:

  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

    How to use code tags

    Just highlight all of the code and press the <> in the post menu above button to add the code tags.


  • Unless that id the Code Name of the sheet then that is not how you refer to sheets in VBA. Try this

    A ComboBox would be an alternative control and easier to code.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!