If you use forms controls you will not need code to put the number into the cell. You can right click > format control > control tab > cell link - choose the cell you want to link to.

The general rule of thumb is that, if you must put controls on a worksheet (as opposed to a userform), then use the simpler 'forms' controls. There's less that can go wrong with them.