+ Reply to Thread
Results 1 to 2 of 2

Generate hyperlinks in an excel cell, and populate the columns in the resulting form?

Hybrid View

  1. #1
    Registered User
    Join Date
    12-27-2016
    Location
    Bangalore
    MS-Off Ver
    2016 for Mac
    Posts
    1

    Generate hyperlinks in an excel cell, and populate the columns in the resulting form?

    Hi Friends,

    I want to know how can i generate a hyperlink in an excel cell and populate the data present in different columns in the same spreadsheet in to a form( form loaded in a webpage after clicking the hyperlink created).

    I would be obliged if anyone could help me with the same.

    Regards,
    Prabhuram

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Generate hyperlinks in an excel cell, and populate the columns in the resulting form?

    Hi,
    Hyperlink can be created like:
    Sheets("Sheet1").Hyperlinks.Add Anchor:=Selection, Address:="http://www.excelforum.com/", TextToDisplay:="Forum"
    Web page address can contain some values from spreadsheet, without any additional data nobody will able to give you ready solution.
    Information can be copied/transfered from excel sheet to web page using VBA. But again - on your super general question just general answers.
    Give us more details, web address of form, upload sample file with "different columns" and dummy data.

+ 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] Generate and populate an email from an Excel spreadsheet
    By MissDB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 03:57 AM
  2. Is excel can generate form?
    By vanther in forum Excel General
    Replies: 4
    Last Post: 04-01-2014, 02:36 AM
  3. [SOLVED] Generate new worksheets from cell names and populate them with relevant info.
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-28-2013, 08:26 PM
  4. Replies: 9
    Last Post: 09-19-2011, 10:39 AM
  5. How to generate + populate new worksheets according to cell value
    By SouthKensington in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-28-2011, 10:54 PM
  6. generate form from excel data
    By frode in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2006, 06:52 AM
  7. how to generate a unique form # when using an excel form template
    By PJE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2006, 06:10 PM

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