Excel -- upon opening, promt for data input
Posted on 2013-11-03
I have a spreadsheet where two critical values drive several associated calculations.
At this time, I've added a simple note in the XLS "reminding" users to ensure reviewing/updated those two values.
However, to ensure they actually are reviewed/changed, I would like to force their data entry upon opening the spreadsheet.
Value #1 (in cell D1): it is an integer ranging between 15 to 25
Value #2 (in cell D2): it is a fraction. It can take on only 3 values (i.e., 1/2, 1/3, or 1/4)
Ideally, the on-opening pop-form will utilize a drop-down menu for value #1. Alternatively, for value #2, radio buttons (or also a drop-down menu) would be great.
Does anyone know how to a) develop the VBA and b) build this linked form?