+ Reply to Thread
Results 1 to 3 of 3

Paste copied value into search box

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    32

    Paste copied value into search box

    Hi,

    I need to open "Application.Dialogs(xlDialogFormulaFind).Show" to find a values previously copied value "Selection.Copy" and then select the range where I need to find the value "Columns("I:I").Select"...

    But I don't know how (or if it's possible) to paste the copied value into the search box with VBA.


    HTML Code: 

    Help, please!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Paste copied value into search box

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    03-26-2013
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Paste copied value into search box

    Quote Originally Posted by mehmetcik View Post
    Please Login or Register  to view this content.
    Thank you, but I would like to use "Selection.Copy" (as in my example) to populate that box. Is it possible?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find last used row in a range, paste it 1 row down, paste copied row as values
    By ExcelEnthusiast7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-20-2018, 05:33 PM
  2. Replies: 3
    Last Post: 12-19-2016, 12:20 PM
  3. Search data copied to sheet
    By Glio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-29-2016, 12:21 PM
  4. Replies: 0
    Last Post: 10-17-2014, 07:26 AM
  5. [SOLVED] Paste previously copied values as 123 except last one and...
    By intex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-30-2014, 04:45 PM
  6. Can't paste copied cell
    By Jaron_t in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-12-2012, 08:47 PM
  7. [SOLVED] Macro to paste copied value to next available row
    By greggatz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-01-2012, 04:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1