Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-26-2018, 05:31 AM   #1
Desiderata
Newly Registered User
 
Join Date: Oct 2012
Location: Corn Belt-USA
Posts: 13
Thanks: 4
Thanked 0 Times in 0 Posts
Desiderata is on a distinguished road
Question Assign Hyperlink

I'm using Office 2013. I was gifted a workbook with text that is supposed to be a hyperlink. I've changed the style to Hyperlink, with no luck. The only thing that seems to work is to enter each cell and insert and select the ENTER key to change the contents to a hyperlink. I have too many rows to do this manually. Is there an included tool to convert an entire column? Please see attached file.

Thanks in advance!
Attached Files
File Type: xlsx Dundolek-Blacksmithing.xlsx (40.9 KB, 11 views)

Desiderata is offline   Reply With Quote
Old 04-26-2018, 10:58 AM   #2
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 5,987
Thanks: 54
Thanked 1,922 Times in 1,836 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Assign Hyperlink

Here. You can find the code st module2
Attached Files
File Type: zip Dundolek-Blacksmithing.zip (54.1 KB, 7 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
Desiderata (04-27-2018)
Old 04-27-2018, 10:31 AM   #3
Desiderata
Newly Registered User
 
Join Date: Oct 2012
Location: Corn Belt-USA
Posts: 13
Thanks: 4
Thanked 0 Times in 0 Posts
Desiderata is on a distinguished road
Re: Assign Hyperlink

Great, thanks so much!

Desiderata is offline   Reply With Quote
Old 04-27-2018, 10:41 AM   #4
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 5,987
Thanks: 54
Thanked 1,922 Times in 1,836 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Assign Hyperlink

Your welcome,,, so go placidly amidst the noise...

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk Update of Hyperlink Text to Display, not hyperlink friedboudinball Modules & VBA 6 08-18-2015 07:19 AM
assign ID Pavczech Modules & VBA 1 10-04-2012 01:02 PM
Can't Assign a Value....Well why not? Rotten Peaches Forms 7 07-25-2012 07:27 AM
Can't assign value charityg Forms 1 06-06-2001 11:13 AM
Can't assign value ListO Modules & VBA 2 03-20-2000 01:55 PM




All times are GMT -8. The time now is 02:45 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World