[SOLVED] userform option button

I'm using the code below on an option button in a userform. The way it should is the following:


userform opens - data will be entered into text boxes....all option buttons a defaulted to "NO".

all option buttons return a value of "1" if "YES" or "0" if "NO"

a command button will enter all data entered into a table

the problem i have is that if the user does not select any of the option buttons (because they want them to be "NO" as they are defaulted to) the option button will not return any value. The user would have to toggle the yes/no button in order for it to return a no.

attached is a sample...although it's not working at all in the sample but i hope it clarifies the problem.

Please Login or Register  to view this content.

Change UpdateRow to LRow