Help with Tag Cloud

Greetings to everyone!

I found a thread that describes and solves exactly what I am looking to do but I can't make it work for some reason...Most likely because it has been sometime since I was asked to do any coding.

here is what I posted in the original thread:

I know this is an older post but it is exactly what I am looking to do with some research I have completed. I have an open ended response located in column B which I would like to do the word count on and then create a word cloud.

My problem stems from my long absence from coding and I can't seem to get everything to work.so my question is; how do I get the second piece of code to run on the set of cells (column b) and then have the chandoo code run?

I have attached a snippet of the responses from the survey.

any help would be greatly appreciated

Thank you


Thank you for any help that you can give.

Try this:

Please Login or Register  to view this content.

Hi John

I'm only interjecting because I see that Shg is off-line and I'm interested in the outcome of your exercise (please post your final code when done!)

Set a reference to Microsoft Scripting Runtime...in VBA Tools-->References-->Microsoft Scripting Runtime.

This should fix this issue

Compile Error:
User-defined type not defined.

John

Hi John

The procedure runs fine on my machine. What line of code throws the error? Do you know how to step through the code? If not, put your cursor in Sub Main then tap F8; this will "Step Through" the code line by line. It'll lead you to the line that is causing the error.

Alternately, run the code. When it halts, select debug. The offending line will be highlighted.

Hopefully Shg will be back tonight. I'll try to help in his absence. Don't pretend to know or understand the code.

John

Hi John

Are you running this code on the sample workbook you posted in your thread? If not, run on your sample and see what happens. The sample is a controlled environment and, on my platform, the code steps right through that line.

If you're running on a different sample, you'll need to post that.

John

See attached. There was a Name error in a cell that was causing it to hang. Also, the code should be in a code module, not a sheet module.

Jaslake, thanks for stepping in to help.

Because the code in sheet modules and ThisWorkbook should be there to handle worksheet and workbook events, not to perform processing relevant to the application.