Setfocus + Sendkey problems

[hamzajosh]

I have a form which has a RTF textbox on it. I am using sendkeys to paste some data into the textbox from the clipboard. The setfocus does not set focus to the textbox via code. If i load the form and run the same code thru a button_click, it works great but if i run the same code in userform.activate, it does not run. the code is as follows

Rtf_Box.SetFocus
Rtf_Box.SelStart = 0
Rtf_Box.SelLength = Len(Rtf_Box.Text)
SendKeys "+{insert}", True

Any help would be appreciated, thanks




Learn everything but implement only what is needed.

 

[fumei]

Is this in Word, Excel? Have you tried making sure the INS paste is true?


TextBox1.SetFocus
Options.INSKeyForPaste = True
SendKeys "+{insert}", True

in the userform.activate inserts the clipboard text into the textbox.

Gerry
Painting/Sculpture site:

http://persweb.direct.ca/gknight/

 

[hamzajosh]

thanks, that worked

Learn everything but implement only what is needed.