+ Reply to Thread
Results 1 to 3 of 3

VBA help to lookup and paste text box value

  1. #1
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    VBA help to lookup and paste text box value

    Could someone help me out with getting this formula into VBA. I have a userform that has a text box in it. When the user enters a number value in this text box I'd like to perform this formula then paste the value from the text box that the user entered into column C.

    The userform will be accessed in a sheet named "Moulder 1" and the lookup sheet is named "Product Code List"


    Here's the lookup formula.
    =IF(ISBLANK(B4),"",VLOOKUP(B4,'Product Code List'!$A$2:$D$298,3,0))

    thanks in advance
    Excel 2010

  2. #2
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: VBA help to lookup and paste text box value

    Sorry I forgot to mention that my text Box that I want to pass the value from is labeled as TextPackSize

  3. #3
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: VBA help to lookup and paste text box value

    In case anyone else needed this here's the code that works perfect for me.

    Please Login or Register  to view this content.

+ 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. pasting colored text doesn't paste via paste special
    By daqddyo1 in forum Excel General
    Replies: 2
    Last Post: 01-08-2015, 12:27 PM
  2. [SOLVED] how can I paste text using paste special, without clicking paste button?
    By Exxcel Noob in forum Excel General
    Replies: 6
    Last Post: 05-14-2012, 08:21 PM
  3. Search lookup array to find lookup value contained within text string
    By Cookstein2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2011, 09:42 AM
  4. [SOLVED] Replace normal paste with Paste As Text
    By lcmbeatrice@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2006, 09:30 AM
  5. Lookup and paste
    By Kstalker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2006, 04:13 PM
  6. [SOLVED] Lookup and paste as value
    By Jody in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2006, 02:45 PM
  7. why my Excel paste as text, coworker paste as numbers?
    By Ian Elliott in forum Excel General
    Replies: 1
    Last Post: 12-19-2005, 06:35 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