ExpExchHelp
asked on
Excel -- upon opening, promt for data input
Experts:
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?
Thanks,
EEH
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?
Thanks,
EEH
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thx... I've added the code to a module (see attached JPG).
Upon opening the XLS, I'm not prompted for data entry.... it goes straight to the worksheet.
Is there another setting I must verify in order for the macro to be called?
EEH
VBA.jpg