Thread: Pasting from the clipboard to the address box of inserthyperlink dialog window in vba
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Pasting from the clipboard to the address box of inserthyperlink dialog window in vba
Application.Dialogs(xlDialogInsertHyperlink).Show

is equivalent to doing it with the menu, so You would probably need to use
sendkeys before that command. Code wouldn't run while it is displayed.


--
Regards,
Tom Ogilvy


"Jay Fincannon" wrote in message
...
after

Application.Dialogs(xlDialogInsertHyperlink).Show

what would be the next line of code to paste the contents of the clip
board into the Address field?

Jay


Reply With QuoteReply With Quote