This is just a general question. I have a userform with all types of
controls (text boxes, comboboxes, option buttons....) I want to store the
user's input each time they run through the program. If it is a combobox, I
store the value of the combobox. Same as with a text box. My question is
what is the best way to store check box or option button values?

For example. If I have two option buttons, obIncludeFreight and
obFreightNotIncluded. In my excel database, I have one column that is titled
Freight. If obIncludeFreight was checked, I store "True" in this column. Is
this the best way to store this type of data? How would I handle it in the
future if i need to change this to a combobox or different type of control?

Thanks,
Steve