User's choice to several checkbox options will place user name on selected worksheets

[SLJones]

User has several options to choose from, utilizing checkbox choices.
(example)
cbx1 = bus
cbx2 = taxi
cbx3 = personal vehicle
cbx4 = train
cbx5 = air

each option has its' own worksheet, and the user may choose more than one option.
depending on which checkbox is checked, the user name will appear on the corresponding worksheet...

Please assist.
Thank you.

[sebak]

Hi,

If you use form control checkbox you can assign below code to first checkbox. It will write users name in sheet named "bus". Modify below code and assign it to other checkboxes.

Sheets("bus").Range("A1").Value = IIf(ActiveSheet.CheckBoxes(Application.Caller).Value = 1, Application.UserName, "")

Hope this helps.

Regards,
Sebastian