Can you have Text Link that acts like command button

I want to be able to have a link that uses cell data as the passed function parameter!

I want to do this so I can simply copy the formula down for new rows and not have to create a command button for each row?

Maybe there is an entirely much easier way to do what I want?

FOR EXAMPLE, the 1st column would be a link to an entry form passing the 2nd column which would be an ID field.

g

It's not clear what you mean. There's ways to autofill formulas, depends which excel version you are using

Unfortunately, I'm not sure how to explain it better. Basically I want a link that launches a Form! But I want to pass a parameter to that Form. That parameter is going to be stored in a cell...

g

Not sure if this is what you mean

Please Login or Register  to view this content.

Copy the code
Select the worksheet in which you the code is to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

I think this is sorta close. But is there a way to make it when you click on a cell in the first column? This appears to run anytime you change any cell? Right?

g

It only works with Column A

Ok, great!!! I figured out that I needed to make some changes to work with my Form and such, and it does launch the form so that is good... Here is the code I have now...

I'm a little confused how to pass the value which is in Column B?

Also, I've can tel the "IF" statement is looking for the "Active" field. The active field is in Column D so how would the syntax go to check for Column D equal to "Yes"?

Please Login or Register  to view this content.

Thanks again for all the great help...

g

I'm not sure what you mean. If the value is not in Column A, but Column B use

Please Login or Register  to view this content.

Dude, thanks a million for the help... From here I need to know how to save thie UserForm to a worksheet, but I'll post to a new thread since it if oft-topic for this thread...

g

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

I did think of one more thing!! Can you help me with adding another condition to the "IF" statement?

I would like this to only launch if the value in Column D is equal to "Yes".

g

Try this

Please Login or Register  to view this content.

Thanks again for the help... This actually was a little incorrect, but I made the following change it it works. Just wanted to repost the code so it might help others...

Please Login or Register  to view this content.

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save