I'm not sure the .characters bit is needed, have you tried:
.OLEFormat.Object.Text = "Form complete!"
I'm not sure the .characters bit is needed, have you tried:
.OLEFormat.Object.Text = "Form complete!"
Hi, still doesn't work. I am using xlsb. do you think this maybe the reson. all my other macros are running fine in the file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks