I need help to show textbox according to value

[Sebastiandiaz]

I have done a simple "Add Data" project, it is very simple, it has to basic userforms. They are called "Enter_Tasks" and Task_View". The first is to enter data from TextBoxes to Sheet called "Tasks", the second one is to display the data already entered. I have placed 2 Colored Texboxes in Task_View userform. I am trying to use these 2 Textboxes(TextBox6 and TextBox7) as measuring data. I mean, if the TextBox6 Percentage value increases or decreases, the size of the Texboxes(6 and 7) to make bigger or smaller on a scale from 1% to 100%.

I am sending you the original file I am using and some images explaining what I need.

Thank you so much in advance.

 

[Belleke]

Does this help?

 

[Sebastiandiaz]

It looks amazing. Wonderful! Thank you.

 

[Belleke]

Glad to help

 

[Sebastiandiaz]

But what if, I have more than 4 or five Charts and I would like to show them in different forms of the same proyect? I tried to do it with the same method, but it causes some conflicts and shows me a message that says error. But it happens when I use the same excel file in another computer. Is there anything that I am doing wrong? I am sending you the file I am using. I did in the same way you did and added the same coding features to the other userforms. Please let me know if when you execute the file, you get any error when displaing the charts in the correspondig userform. Thank you in advance.

 

[Belleke]

I don't get any error.
Can you post a screenshot of that error

 

[Sebastiandiaz]

The error that "Run-Time error '481':
Invalid picture.

it happens with all the userforms that have a chart on it. The last file I sent was a test to find out if someone is wrong, but you told it works ok. The file I am sending is the one that I am originally working on. I run it from My PC(Windows 8.1, Office 2016) it works perfectly, but when I run the same file in my job computer(WIndows 10, Office 2013) it causes those errors. I don't know if it is something wrong in the coding or it is something related to the Windows Version.

 

[Belleke]

Does this one works?

 

[Sebastiandiaz]

Yessssss! That is exactly what I needed. Can you tell me what was I doing wrong?

 

[Belleke]

I couldn't find nothing wrong, just make your sheets visible, click on the chart and hide your sheets again.

 

[Sebastiandiaz]

Wow! Really? Unbelievable! Thank you so much.

 

[Belleke]

Glad to help.