Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
clipboard problem

Forum home » Delegate support and help forum » Microsoft VBA Training and help » Clipboard Problem

Clipboard Problem

ResolvedVersion 2010

Roger has attended:
Excel VBA Intermediate course

Clipboard Problem

I am running a macro in Word which creates mirror image Odd & Even Headers & Footers, i.e. the left & right parts of the even headers & footers are swapped over compared to the corresponding odd ones. To do this, for example, I cut the applicable left header part & then paste it to the right header part. When I run the macro, certain headers are blank. However, when I single step through, it works perfectly. Is it possible that when I run at normal speed, the clipboard is being cleared? Would it therefore be better to store the text in a buffer rather than in the clipboard?

RE: Clipboard Problem

Hello Roger,

Thank you for your question. My colleagues and I have had a look and realised that we regrettably can't assist you with this. Word VBA falls outside of our scope of knowledge and training courses. We only train VBA in Access and Excel.

I do apologise for this.

Kind regards
Marius Barnard
Excel Trainer

VBA tip:

Display Text In a Msgbox On Multiple Lines

When displaying text in a MsgBox you may need to show it over multiple lines. To do this use:

vbCrLf

As in:

MsgBox "The System has detected an error." & vbCrLf & "Contact your System Administrator"

The first sentence in quotes will appear above the second in the MsgBox.

View all VBA hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.