Paste text from Clipboard into Text Box

[ne1983]

Hey There - just need some VBA that will paste data from the clipbaord into a specific textbox.

Context = user copies a URL from web browser - and then just needs to hit one botton that pastes the URL into the [DB_Links_Executable] text-box(just to save having to click into the box and press CTRL V)

Thanks

 

[ne1983]

actually sorted it thanks all

 

[missinglinq]

Forum etiquette dictates that when the original poster solves the problem by himself he posts the solution, so that others having the same problem may benefit.

That being said, the simple solution to this would have been

Private Sub cmdPaste_Click()
 Me.[DB_Links_Executable].SetFocus
 DoCmd.RunCommand acCmdPaste
End Sub

Linq ;0)>

 

[Thales750]

actually sorted it thanks all

https://www.youtube.com/watch?v=yau7Z3vMBo0