Text box to populate based on drop-down list cell value while sheet is "protected".

Hello!

I have a code that i cannot get to work properly. Please note I have almost ZERO experience with Macros/ VBA and know very little terminology. I do know a little bit and have been able to figure out little things here and there.

Here is what i am trying to do.

I have a drop-down list in cell C2 in the "Input" sheet that has the option for value "Good Faith Estimate" or "Lump Sum Quote".
I have a text box in the "Quote" sheet that is named "TextBox6".
I have 2 cells (J16 and J18) in the "Wages & Rates" sheet that have some text in them.
I would like for "TextBox6" to populate with the text in cell J16 on the "Wages & Rates" sheet if C2 in "Input" sheet has the value "Estimate" selected from the drop-down.
And
I would like for TextBox6 to populate with the text in cell J18 on the "Wages & Rates" sheet if C2 in "Input" sheet has the value "Lump Sum" selected from the drop-down.

I have been able to get this code to work if i wanted to populate the values into a cell, however, i want to populate it into a text box instead.

Please note that i have the code placed into the Sheet1 (Input). Here is my code below:

Please Login or Register  to view this content.

Thank you very much! I can attach the file if need be, i just need some guidance on what you think.

Originally Posted by AlphaFrog

Your code should work for a textbox as well. Make sure the two Target values are exact matches to the C2 dropdown entries. Shouldn't they be "Good Faith Estimate" and "Lump Sum Quote" ?

Please Login or Register  to view this content.

Hi! Thank you for the reply. Yes those are the correct values i have in there i forgot to update when for my original post. So every time i try the macro i get this

Run-time error '438':

Object doesn't support this property or method

After selecting debug option, it highlights the row pertaining to the value. So if i select "Good Faith Estimate", then the error message shows up and once i hit debug then it hight lights this row:

Please Login or Register  to view this content.

Then it does the same if try it with "Lump Sum Quote"

Please Login or Register  to view this content.

Originally Posted by AlphaFrog

My guess is that you don't have an ActiveX-type textbox named Textbox6 on the Quote sheet.
- Double-check the exact name of the textbox.
- There are two types of textboxes; an ActiveX-type and a Forms-type. If you used a Form-type control, try this syntax.

Please Login or Register  to view this content.

Exellent! It worked! I just had to change ("Text Box 6") in your code to ("TextBox6") as you suggested and it worked great! Thank you so much.

I have another question that i can start for another thread for if you think i should but it still pretains to this code. How can this code be used if i have the sheets all protected? This workbook has many protected cells with formulas. Employees are meant to use this and be able to use the macros and edit cells that arent locked.

I dont know how to invorporate this yet:

Please Login or Register  to view this content.

And this at the end:

Please Login or Register  to view this content.

The 2 seperate codes below work but i do not like the way the .Unprotect and .Protect feature works.

Please Login or Register  to view this content.