Recent content by AdrianScaife

try ThisDocument.CheckBox1.Select It seems to work for me

Sorry ignore my last post I was thinking of something else! Aer you using the VBA Controls Checkbox or the checkbox from Excel Forms?

If my memory still serves me you can put a label just before the checkbox in the tab order and when the label receives the focus it gets bumped on to the Checkbox

you need to assign the yes or no that the message box creates to something by putting brackets round the parameters eg Response = MsgBox (("Have You Selected a Cell in Column A and below Row 77"), vbYesNo, ("DVW Workbook")) then your if statement should work

Excel XP has a useful function on strings: Function Split(Expression As String, [Delimiter], [Limit As Long = -1], [Compare As VbCompareMethod = vbBinaryCompare]) you can use in a varity of ways depending what you need. Otherwise without using VBA try Data-Text to Columns

How about using find as you have been and then checking the starting position of the "100000" using InSrt. You can then check that the next character is not a "0" easily enough

the problem comes when you try to copy to H14 which does not exist as a cell in its own right.

Have I missed the point entirely? Surely the whole point of VBA is that there are much better ways of doing everything than using send keys? If you are not confident enough to write the code from scratch why not record a macro? Even if it does not provide the worlds most perfect code its a...