-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
PLEASE HELP ignorant student!
- Thread starter LMF
- Start date
Excel Facts
How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
sorry Jeanie, but without even a little snippet of VBA i'm not sure that would be possible.
Formula alone cannot write to other cells. The only other perceivable way of doing it is to have formula in sheet 2 to pick up the values from your "worksheet-form", but there would be no way for the formula to remember old values that were previously in the form.
But if you can get away with just a little VBA then you can easily wire up your form to your data sheet. Otherwise, use access (as you say) or use the built in data form.
Why can't you use VBA - thats screwy.
Formula alone cannot write to other cells. The only other perceivable way of doing it is to have formula in sheet 2 to pick up the values from your "worksheet-form", but there would be no way for the formula to remember old values that were previously in the form.
But if you can get away with just a little VBA then you can easily wire up your form to your data sheet. Otherwise, use access (as you say) or use the built in data form.
Why can't you use VBA - thats screwy.
Upvote
0
Just to get you started, from the mentioned Forms toolbar, place an option button on the worksheet. Now right click on the button and goto |Format Control. Hit the control tab on the now opened dialogue box, click in Linked Cell. now click on the cell you'd like to put the value from your option button, this can be on any sheet.
Also, you could look at the buttons on the |Control Toolbox. to link cells from these type of controls, again Right-Click on the control you have and select |Properties|Linked Cell, you'll have to type the link in.
I don't know if your thinking of trying to fill in the form on 1 sheet and have a list on the other, i.e. from many times of filling in the form, sort one under the other. Unfortunatly youe NEED to use code for this.
BUT! if you want to create a form the does calculations from various inputs then your on to a winner.
Any of this any help?? if you need more just ask.
Also, you could look at the buttons on the |Control Toolbox. to link cells from these type of controls, again Right-Click on the control you have and select |Properties|Linked Cell, you'll have to type the link in.
I don't know if your thinking of trying to fill in the form on 1 sheet and have a list on the other, i.e. from many times of filling in the form, sort one under the other. Unfortunatly youe NEED to use code for this.
BUT! if you want to create a form the does calculations from various inputs then your on to a winner.
Any of this any help?? if you need more just ask.
Upvote
0
Similar threads
- Question
