Posts by ozex11

Quote from alansidman

Be sure that macro is embedded in the correct file. Ensure that macros are enabled on all computers.

the macro is embedded in the correct file

Can I do the activation you mentioned in the excel file I made?

Let the macro activate automatically when the file is opened, regardless of computer and location.

Hello everyone

I have an excel file with macro.

When I move or rename this file or open it on another computer, the macro is disabled.

Is there a way to actively start this?

Let it be active when I open it on another computer, not on one computer. is this possible?

Or

can it prevent editing and viewing of data in excel file without enabling the macro?

thanks in advance for the help

Quote from Carim

Yes ... obviously you are right !!!

The total is 100% ...

But the display format does not show the figures after the decimal separator ...

Behind the display, the actual numbers in Excel are : 12.50% and 87.50%

Display More

my teacher

I think problems will be difficult to solve but they are easily solved

You've been so helpful that I'm ashamed to open another thread on the forum.

Thanks again

Quote from Carim

Yes ...

You do need to write "Invert" next to each question which needs to be treated this way ...

Because only your eyes and your interpretation of how the question was asked can determine the Type of each question

my teacher

Thanks for your reply

I have another question

number of participants 8

yes-1 no-7 answered

I use the formula to find the percentage of these answers.

result 88% 13%

Shouldn't the total be 100%?

Quote from Carim

For your very last question ... with no colors ... see attached

thanks

Do I need to write "invert" or "standard" next to each question before starting the process?

Quote from Carim

Hello again,

See attached test file

my teacher

Topic closed, but I have one more question.

You used "red" "green" when writing "positive" and "negative" comments, why did you use it?

While making changes, I noticed that when I delete these color names, the values change, how will it be without the color names?

no colors in the poll

Quote from Carim

Haklısın

Böylece bu konu çözüldü :başparmak yukarı:

thanks to you

Quote from Carim

Thank you for your comments.

Do you mean that the Test file (with the attached chart) does bring an answer to your initial question ?

Isn't it the last file you gave the solution to the first problem?

made sense to me

Note:

The red and green colors don't matter in the file I sent.

I made those colors just to make it clear that they are "positive" and "negative" questions.

Quote from Carim

Hello again,

See attached test file

my teacher

You always come to help tirelessly.

Honestly, this method had never occurred to me.

I wrote it as a comment in cells 9-10 but it was no longer needed.

because you understand the subject very well

Quote from Carim

Hello,

What you are asking for is, in fact, rather simple ...

However, the first you need to do is build your worksheet structure in a sample file ...

Hi teacher

first of all thank you for your help

I use google translate and it doesn't translate exactly so I don't quite understand what you mean

Frankly, I have no idea what to do with the file you sent.

Can you show it with the file I sent?

Hello everyone

I have a question

I have a survey I made in Excel.

I need to find the percentage of this survey and graph it.

However, there is a different situation. Some questions are "positive", some are "negative".

sample survey question “shoes satisfaction survey” (total number of participants 18)

Yes No

question 1 - does it smell? 10 - 8

question 2 - is it easy to clean? 15 - 3

Those who said yes to the first question said yes to a "negative" situation for this shoe.

however, those who answered yes to the second question said yes for a "positive" case.

In this way, there are 20 different questions.

Based on these data

% pleased

% not glad

I need to find a ratio.

(Considering the positive and negative question)

After doing this I need to show it in graph.

can you help me?

Sorry for my English (Google Translate)

Quote from Carim

Kullanıcı Formunuzda 'Ekle' ve 'Sil' için benzer sonuçlara sahip olmak için aynı çok küçük değişiklik

you again

great job again

I want to thank you again

Quote from Carim

When you say:

it doesn't shrink when i delete data and unfortunately it doesn't expand when i log in manually.

Just manually re-type the last data in the last row in Column C

I didn't notice that detail

thanks

Sir, I think the working principle is as follows

"enter data manually"

I fill columns a-b-c and it expands automatically.

To collapse it, it is necessary to delete column a-b-c "in order".

"with user form"

It expands automatically when I enter data.

but when I delete the data the width stays the same.

Quote from Carim

Hello,

A very very small modification for your UserForm ...

Code

' Adjust Column Width
  .Columns("A:C").Columns.AutoFit

Thank you teacher

health to your hands

I have a question,

it doesn't shrink when i delete data and unfortunately it doesn't expand when i log in manually.

With the code in the topic below, it automatically expands the cells I enter data into the table manually.

but how can I do this when entering data with "useform"?

Thread

AutoFit Column Width Macro

Hi All, I found some code to automatically resize columns. It works great for anything I type into a cell, but will not work for data entered via a userform unless I subsequently click onto the column. Any help is appreciated... Thanks

creativespace

Jul 3rd 2010

Quote from Carim

Well ... If you manually add data in your Sheet2 ...

As soon as you enter data in the last row in Column C ...

the whole table is automatically sorted ...

Sir, you are a very kind hearted person.

you've been helping me for days without being lazy

There is a saying in the Turks that "Your right is not paid".

(an expression used to show gratitude to people who have helped someone a lot)

really, really thank you so much

Quote from Carim

OK ...

Attached is a small modification for future updates

To see how it works :

- Go to Sheet 2

- In cell C5, just type data2 - Enter

Display More

my teacher

Ignore my ignorance, I did not fully understand the working principle of this

Quote from Carim

TAMAM ...

Kopyalamanız gereken tablo ayrıca 3 Sütun var mı?

Yes that is right
do you have a problem

Quote from Carim

OK...

You also want to enter data "manually" or directly in Sheet2 ...

How ...?

I hope it's the right understanding.

I already have an excel file, I will transfer the table in that file here.

then i will add new data to be added with "useform".

Quote from Carim

Concerning the Manual input ... could you explain how do you plan to do it ?

I am really sorry

I don't quite understand what you're saying. Google translation is missing or mistranslated, can you ask another way?