Insert Specific Values From Form To Specific Cell

[DYLANATT1999]

Hi,

I understand this is a long shot, but this is well over my head.

Basically, I am creating a calculation sheet. I want the user to use a form which will then enter inputted information from the form to the excel sheet and then the results which will be cell C68 and C69 will be displayed on the form.

For example the form with the

text box "Span" will always go into C12 of the worksheet
text box "Support Height" will always go into C13 of the worksheet

I am also trying to get the list function to work on the excel sheet. For example, "Electrical Wire Diameter" can ONLY be 0 , 6 , 8 , 10.1 - which can be seen in the drop down list on C25

The sheet in question is called "SIMPLIFIED CALC SHEET"

I have created a form called frmForm for this already.

I have tried to do the code, but I am well out of my depths.

Any help will be appreciated!

EXCEL ZIP DOWNLOAD

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Enter info from form to excel sheet
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[DYLANATT1999]

Enter info from form to excel sheet

Hi, I understand this is a long shot, but this is well over my head. Basically, I am creating a calculation sheet. I want the user to use a form which will then enter inputted information from the form to the excel sheet and then the results which will be cell C68 and C69 will be displayed...

www.excelforum.com

Noted Thanks