Populate userform radio (option) buttons based on data in worksheet

Hi everybody.

I have a worksheet with row entries of client profile information. In order to protect the data from user error, a Userform is used to edit the client's contact information. By clicking on a button, "Edit Client", an Input box is loaded asking the user what client ID# they wish to edit. This number input is put into a textbox on the userform, and all the textboxes and radio buttons on the userform are populated by referencing the Row# that the Client ID# appears on in the worksheet.

Currently, all the textboxes are populating perfectly. However, the radio button selections are not populating correctly. When the userform initializes, the radio buttons will not populate. BUT... BUT... I have a command to re-initialize the userform if the Client ID# is changed on the userform, and if that is triggered the radio buttons populate correctly.

I have been scratching my head why and I can't see what the problem is. So, I am reaching out to see if anybody else has had this problem, or can offer a solution.

Anybody have any insight?

Code:

Please Login or Register  to view this content.

Ah, brilliant. Select Case, a much better approach! Thank you for the insight.

I will try this in the morning and update the thread with a result and comment.

Much appreciated!

Worked perfectly. I will apply this technique to other userforms as well. Thank you very much!!