Carina33
12-12-2006, 11:45 AM
Hi,
I have a sheet in my model that looks very messy with lots of macrobuttons asking the user to enter different values in input boxes.
Please could someone let me know how I can improve my design? I have read a little about userforms and that this should allow the user to enter all the necessary values in one ago (without having to go through several different prompts...)? Problem is I don't know the technique for user forms. Can someone help? I need to ask the user to enter eight values in A14, B14, G14, J14, A25, B25, G25 and J25 in sheet 1. The user should be able to leave any one of these selections empty in which case a default value should be be used and stored in each of these cells. The default values for each cell are in sheet 2.
If I can't use a userform to improve things please let know of any other alternatives.
Can anyone help? Would be a real lifesaver!
Many thanks in advance
C
I have a sheet in my model that looks very messy with lots of macrobuttons asking the user to enter different values in input boxes.
Please could someone let me know how I can improve my design? I have read a little about userforms and that this should allow the user to enter all the necessary values in one ago (without having to go through several different prompts...)? Problem is I don't know the technique for user forms. Can someone help? I need to ask the user to enter eight values in A14, B14, G14, J14, A25, B25, G25 and J25 in sheet 1. The user should be able to leave any one of these selections empty in which case a default value should be be used and stored in each of these cells. The default values for each cell are in sheet 2.
If I can't use a userform to improve things please let know of any other alternatives.
Can anyone help? Would be a real lifesaver!
Many thanks in advance
C