Msgbox not big enough

[chun25011]

Hello,

In my excel table, I have a column of cells that contain a lot of data. And I use VBA to make a msgbox pop-up when I click on that particular column of cells, to show the content of the cells.

However, some of the cells contain data that exceeds 1024 characters and somehow the Msgbox is not big enough to display everything.

Would there be any alternative for this? I am using a Mac so it is not convenient to edit a userfrom, apart from Userform and msgbox, is there any other simple way I can display the content of the cells upon clicking on them?

Thanks in advance.

[shg]

Use a textbox autoshape?

[chun25011]

Thank you for your idea. How does a textbook autoshape work exactly?

[huuthang_bd]

Try this

Please Login or Register  to view this content.

[chun25011]

Sorry, I tried but same, I am not quite sure how to make this work...

[chun25011]

Hi, please could you enlighten me on how to apply your suggestion? I have been searching on the internet about Application.Assistant.DoAlert, but it happens that there aren't many ressources about how to put this method into use. Thank you so so much.

[nigelog]

Pass your string or values like so

Please Login or Register  to view this content.

[nigelog]

try this - change range to suit

Please Login or Register  to view this content.

[chun25011]

Thank you for your reply!
However, I get this error when I run the code...

[nigelog]

Hi, give me 10 minutes and I'll try sort something

[nigelog]

Id say userform best option - Userform with one label

Please Login or Register  to view this content.

[chun25011]

Thank you so so much for your help!

This seems to be a good idea and I succeeded to make it to work!
However, the Userform just can't happen to resize correctly as expected. I think this is due to the format of data that I'd like to show.

All the cells that I'd like to show is more or less like this, with linebreaks...:

"
1.2.3.4 - Dégagé devant dedans dehors demi-plié première

idem seconde

idem derrière

5.6.7.8 - cambré

idem en dedans

"

[nigelog]

Is it line breaks you want to remove??

Please Login or Register  to view this content.

[chun25011]

I have been trying to apply the code that you've written and it finally worked! thank you SO SO MUCH!!!!!