I have a worksheet and what I want is that when one clicks a row, a popup
form will show up, displaying the data from that row in a more user friendly
screen. The worksheet will be generated programatically and could have
thousands of rows.

How can I link the row / cell to a form? Is it possible not to use a
worksheet control? I hope it will be simple enough so that when the form
shows up, I can calculate what row was selected in the sheet?

Any help will be appreciated.