+ Reply to Thread
Results 1 to 6 of 6

How to put text into a box on the web. Then extract the text from another box to worksheet

  1. #1
    Registered User
    Join Date
    08-03-2015
    Location
    Iceland
    MS-Off Ver
    0002
    Posts
    17

    How to put text into a box on the web. Then extract the text from another box to worksheet

    I want to be able to enter the text into the top box on the website and then be able to take the text from the bottom box into the excel work sheet.


    Please Login or Register  to view this content.
    Afterwards, I would like to be able to make my own function to be used every where in the the work sheet. Is it possible to turn this into a public function and reference a different cell for the source and its own cell as the destination. If so, how?

  2. #2
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: How to put text into a box on the web. Then extract the text from another box to works

    Hi Jazee,

    You should trigger the js functions:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: How to put text into a box on the web. Then extract the text from another box to works

    btw, i can't get it into ws function.
    Somehow the value tɛst will go into t?st on my version of excel once assigned to a varible.
    You can try it offcourse....

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-03-2015
    Location
    Iceland
    MS-Off Ver
    0002
    Posts
    17

    Re: How to put text into a box on the web. Then extract the text from another box to works

    Thanks for the reply. I don't know how to use functions function. It would be appreciated if you could help me do it. I want to use the function to reference a cell like in this youtube video: /watch?v=ab_9cldJ_ds

  5. #5
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: How to put text into a box on the web. Then extract the text from another box to works

    Hi Ja Zee,

    The sub in my 1st post does work, have you tried it?
    The Function in my 2nd post doesn't, because the value tɛst will go into t?st once assigned to a variable. I think this has something to do with the fontset used by VBA.
    I don't know a solution to this, so can't work out a (public) Function for you.

    Regards,
    Rick

  6. #6
    Registered User
    Join Date
    08-03-2015
    Location
    Iceland
    MS-Off Ver
    0002
    Posts
    17

    Re: How to put text into a box on the web. Then extract the text from another box to works

    Thanks, I was able to solve the problem.
    Last edited by Ja Zee; 09-12-2015 at 11:20 AM.

+ 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. Replies: 4
    Last Post: 08-13-2014, 11:03 PM
  2. [SOLVED] Extract text from a given point in a text string, when data points do not share the given
    By reedersketer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2014, 03:57 PM
  3. [SOLVED] Extract 50 characters text to a new worksheet
    By skyflare in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2013, 01:44 AM
  4. [SOLVED] Extract text from a string of text (amend formula to include new criteria)
    By robertguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2013, 04:53 PM
  5. How to extract specific text from a worksheet
    By badbronco in forum Excel General
    Replies: 18
    Last Post: 11-12-2009, 11:59 AM
  6. I would like to extract some text in my WorkSheet Tab and enter it
    By Dr. Darrell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-08-2005, 08:25 AM
  7. Replies: 1
    Last Post: 11-22-2005, 07:15 AM

Tags for this Thread

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