This is a short answer because it sounds like you know what you're talking about already.
Actually in your case, a user form with several controls would probably work better.
Right click on your VBA Project in the editor and Select Insert User Form. Drag and drop controls onto the the form.
Attached is an updated macro. It is incomplete, but you can see how I added the controls.