Hi

I have a userform which adds/updates staff information - this has been
achieved by the fantastic resource that this forum is.

My userform has three option buttons which I can populate to the
spreadsheet by the caption of the selected option button - what I am
having trouble with is populating the optionbuttons from the
spreadsheet to the userform. I have the textboxes etc covered (from
userform to spreadsheet and spreadsheet to userform), just stumped on
the optionbuttons ...

My optionbuttons are within a frame titled; "Employment status",
permanent, temporary and ex-employee.

I had originally fixed this by removing my optionbuttons, and using a
textbox, however the optionbuttons I believe is the easiest for the
user, and limits the entries.

I can add in the code that I am using within the next 24 hours - my
spreadsheet is on my work pc.

Appreciate any assistance with this matter.
Thanx, Tania