Can I run a macro after i've pasted?

[tonywatsonhelp]

Hi Everyone

I'm having a few problems with people wanting to copy data from word and paste into a single cell in excel as excel wont do this the way they want to so i've created a textbox for them to paste into.

but what i need is for a macro called "Tide_up" to run after they have pasted

is it posible to have a macro run after the paste has happened? i cant use active x textbox as you cant right click paste into it.

any ideas would be helpfull.

Thanks

Tony

 

[tonywatsonhelp]

Thats excellent Jaafar,
thank you very much for your help.
This has made things much better.
Thanks
Tony

 

[Jaafar Tribak]

Thats excellent Jaafar,
thank you very much for your help.
This has made things much better.
Thanks
Tony

Tony,
Glad I could help and thanks for the feedback.

 

[tonywatsonhelp]

Now just to be a pain, would it be possible to have two options Paste and paste values? some people do one some the other!

Thanks again for everything you have done

Tony

 

[Jaafar Tribak]

Now just to be a pain, would it be possible to have two options Paste and paste values? some people do one some the other!

Thanks again for everything you have done

Tony

Unless I am missing something, only values can be pasted from the clipboard onto the textextboxes . Formatting is not pasted along ... Am I right ?