This probably requires just a simple Yes/No answer (A little more than that would be appreciated!)
Can a user form be used to do away with a user entering any data int a spreadsheet? I want the user to be able to enter information into the form, for the sake of argument, weight of a parcel and service required, and have the input passed to a sheet which does all the calculations and then pass the result back to a text box or label on the user form.
If the answer is yes, I will go away and try and find out how to do it - I have not used user forms so I think the best way is to try them out once I know what I want is possible.
Dave
Can a user form be used to do away with a user entering any data int a spreadsheet? I want the user to be able to enter information into the form, for the sake of argument, weight of a parcel and service required, and have the input passed to a sheet which does all the calculations and then pass the result back to a text box or label on the user form.
If the answer is yes, I will go away and try and find out how to do it - I have not used user forms so I think the best way is to try them out once I know what I want is possible.
Dave