Excel question.....other than hyperlinking is there a way to have a link that when pressed...?

Question

....makes the information pop up on screen?

Answer 1

There are a number of ways to do this, and it depends on your proficiency. You can just insert a comment which will show the info when the mouse goes over it (apologies if this is teaching granny to suck eggs). Another way is to use the control toolbox to insert a label or formated button on your worksheet and then attach code to the back of this along the lines of:

Sub MyButton_Click
msgbox("This is what I want to say")
end sub.

There are other things you could do as well, so if you google this question you may find some more help on forums.

Another thought - if you mean actually have the info appear on the worksheet you can still use the technique above - let's say you want to make something populate in ranges A1 to A3 when you click your control:

Sub MyControl_Click
range("A1").formula = "The first info is here"
range("A2").formula = cells(row, col) / 3 'as an example
range("A3").formula = "Something else here"
end sub

There's loads of other options too - you could put the whole thing in a macro that fires on a worksheet event for example. If you add more details to the q I'll check back and try to answer more precisely.

Answer 2

how are you able to all be so blind? how are you able to all not see the handwriting on the wall? the two events SUCK! fix the Republic! shelter the form! it incredibly is time for human beings to stand at the same time and institute actual replace! a replace that takes us back in time to whilst actual replace became made. replace that began on the 18th of April, 1775 whilst a shot became heard around the international and a central authority of the human beings, with the aid of the human beings and for the human beings became fought for and carried out. There are actually not to any extent further 2 events. There are 2 segments of one party - the RepubliCrats. 2 palms doing fairly some issues to realize an identical end. And interior the tip - no remember which way we get there- WE the human beings LOSE! awaken usa! you're dropping your liberty. Your rights are incrementally being stripped away collectively as you draw lines interior the sand between one yet another. it's time to charm to a line interior the face of the politicians and then STAND on that line! people who've been elected to lead us look to have confidence they RULE us. Tyranny should not be tolerated!!! Make a stand. PATRIOTS UNITE!!!

Answer 3

do u like my boots?