VBA to link cell to website regardless of cell content.

[MJ72]

Hello all!
I am setting up a data base for my coworkers and one column is a client phone number column.
I would like to create a vba that will link the cells in that column to a specific website that won't change even when my coworkers enter and/or change the phone numbers in the cells of that column.

I have been successful, just linking the column cells to the website (that part is an easy right click, as you know) but as soon as the phone number is deleted, changed or a new one is added, it overrides the link and clicking the cell then goes nowhere. How do I "lock" that website to the cells in that column so that regardless of the cell content, clicking on the cell always goes to the website?

Thanks

MJ

 

[MJ72]

I must be tired, I'm an idiot... ms Forms 2.0 checked... but still having the issue of it autopopulating the phone number into every cell in the column. It does, however, open the proper website upon being clicked and does copy the phone number allowing it to be pasted in the search bar of the website as desired.

I've tried playing around with the order of your first and second sets of code and I just can't seem to stop it from autopopulating AND have it continue to work properly.

 

[Candyman8019]

Do you have other formulas in the rest of the column?

 

[MJ72]

Do you have other formulas in the rest of the column?

No.

 

[Candyman8019]

Is your data formatted as a table?

 

[MJ72]

Yes, it is.

 

[Candyman8019]

Okay that makes sense. When you put one formula in a column of a table it copies it to the entire column. Here’s a thread with some tips to prevent the table from doing that.

How to Prevent or Disable Auto Fill in Table Formulas - Excel Campus

This post describes how to undo the automatic filling of formulas in columns when you add new formulas to tables in Excel.

www.excelcampus.com

 

[MJ72]

That was it! Thank you very much, Joe!
Cheers

MJ

 

[Candyman8019]

My pleasure! Happy we were able to get you results.

 

[smozgur]

That was it! Thank you very much, Joe!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.