I have just made a combo box with 5 option(s). It is hovering above B2, but
it is not in B2.

If I wanted to use the value of the combo box in a formula elsewhere, how do
I reference that?

Bonus: I have a Calendar UserForm. Right now, it places the date in
whatever cell was selected when I clicked it. How, instead, can I aim it at
a particular cell every time? And how do you lock your buttons, controls in
place in your spreadsheet?

Thanks for your time.

Arlen