Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support

Excel 2007 Macro Help (Buttons)

This is a discussion on Excel 2007 Macro Help (Buttons) within the Microsoft Office support forums, part of the Tech Support Forum category.


Closed Thread
 
Thread Tools Search this Thread
Old 01-28-2009, 08:55 AM   #1
Registered Member
 
Join Date: Jan 2009
Posts: 1
OS: xp sp3



Hi I was wondering if someone could help me.

I am creating a fairly simple excel data sheet to help out in work. I'll explain what I am trying to get it to do, then you might get the idea of where I am going wrong and hopefully point me in the right direction.

I deal will a lot of return parts from one manufacturer and at present we have to look up each part number of there on line site to see what it is.

So I have set up a spreadsheet with the first column containing the common search parameter replicated in each cell:

Example: http://h20141.www2.hp.com/hpparts/Se...earchCriteria=

And the next column has the barcode part numbers scanned in

Example: A9739-69008

In the following Colum I placed the formula =HYPERLINK(A1&""&B1) then copied and pasted in all the cells in the column.

The combined result gives me a hyperlink to that parts information:
http://h20141.www2.hp.com/hpparts/Se...ia=A9739-69008


Now although this works great as a hyperlink to each part description, it looks untidy.

What I want to do is create a button that can be pressed on each row than can do the same thing withoutlooking so untidy.

I tried to create a macro for a button on the first row with the following code:

Sub HP_link_2()
ActiveWorkbook.FollowHyperlink Address:= Range("C1"),
NewWindow:=True
End Sub

But it’s nowhere near right.

Can someone help please?

__________________
Chris Littlewoo is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2


All times are GMT -7. The time now is 03:11 PM.


Copyright 2001 - 2014, Tech Support Forum

Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts